On Mittwoch, 11. Juni 2008 Devendra Singh Rawat wrote: > And in less than 8 hours it has bloated to additional 3.7GB (the disk > size now is 7.2GB). > > There are quite a few DML operations which are happening on my DB. > > SELECT relname, relpages FROM pg_class ORDER BY relpages DESC; > relname | relpages > -------------------------------------------------------------+------- >--- < table1 > | 180676 And after VACUUM FULL, is it small again? Maybe you need to run it 2-3 times a day, for your specific workload. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4
Attachment:
signature.asc
Description: This is a digitally signed message part.
