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?
On Wed, 2010-03-03 at 08:32 -0500, akp geek wrote: > 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
Plain vacuum does not file system size of relations. It just marks dead 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