Postgres volume space
fra
HOBBYTop 10% ContributorOP

25 days ago

Hello,
this is not a real issue, more a curiosity on my side, I had a db with (I think) pg 16, I've now created a new db with the latest template, so pg 17, the volume usage is double of the previous db, the new db was empt, I've now added a few rows but nothing big….you can se in the graph that since the beginning the db was bigger then the previous one…any idea why?

3 Replies

Probably cached bookkeeping data being flushed out


(i.e. logs or transaction data)


fra
HOBBYTop 10% ContributorOP

25 days ago

probably I didn't explain myself correctly, this is the last 30days, the db in green is the old db (pg16) and it had for sure more data then the new one (pg17 purple) that is brand new….if you just deploy a new pg17 is double the size of pg16….now, just to clarify, is not a big deal, just curiosity why the new template by default is x2 the size of the previous template

1463236479915655200


Loading...