Hi All -
I have turned on the auto vacuum on the slave and for some reason the db is getting bloated up. The master size is only 1G and the slave is at 9.2GB now. I did cluster on couple of tables also. did any one run into this situation? Can you please help?
Regards
2010/3/3 akp geek <akpgeek@xxxxxxxxx>
I just made changes to postgresql.conf to make sure the autovacuum is turned on and I will update you.. Again thanks for your timeRegards2010/3/3 Devrim GÜNDÜZ <devrim@xxxxxxxxxx>
On Wed, 2010-03-03 at 08:32 -0500, akp geek wrote:Plain vacuum does not file system size of relations. It just marks dead
> Thank you all for the suggestions. I did a vacuum and the size has
> gone down drastically. But still it is not the same size as my master.
> I am looking into it
spaces are writable. If you haven't vacuumed for a long time, it
probably means that you have lots of space to be reused.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
