Re: FSM and VM file

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(at)gmail(dot)com>

> I just made changes to postgresql.conf to make sure the autovacuum is
> turned on and I will update you.. Again thanks for your time
>
> Regards
>
> 2010/3/3 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
>
> 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
>>
>
>