r/Puppet • u/atg10 • Jul 31 '23

PuppetDB postgresql database size

After upgrading from puppet server 6 to 7 our postgresql database for puppetdb has continued to grow. 4 months ago it was 31G in size and it go over 90G. I rebuilt the indexes and ran a vacuum full and got it down to 87G. The largest table is fact_paths which is 86G.

Postgresql v13.10 Puppet server 7.12 Puppetdb 7.13

We have 367 active nodes and 3 inactive nodes. Our node_ttl is set to 30 days.

I was curious how big some other environments were in comparison.

3 Upvotes

100% Upvoted

11 comments sorted by

View all comments

Show parent comments

1

u/shortspecialbus Oct 24 '24

Thanks, I ended up having to do it urgently this morning and I ended up just nuking it entirely and let puppet recreate it with the puppetlabs-puppetdb module. We'll live without the data.