[Bucardo-general] fsm and vm files generated under $PGDATA/base

[akp geek]

Hi All -


                I have turned on the auto vacuum on the slave still  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


On Tue, Mar 2, 2010 at 4:43 PM, akp geek <akpgeek at gmail.com> wrote:

> The only reason I got concerned is after I started the replication
> process, the size of my $PGDATA on master is about 849M and on the slave is
> 7.8G. It's growing tremondously. I am not able to figure out why.
>
> All I have one master is bucardo and the database that I am trying to
> replicate. That's it. any clue why the size of base directory is getting
> increased?
>
> Regards
>
>
>
> On Tue, Mar 2, 2010 at 4:18 PM, Rosser Schwarz <rosser.schwarz at gmail.com>wrote:
>
>> On Tue, Mar 2, 2010 at 1:56 PM, akp geek <akpgeek at gmail.com> wrote:
>> >              During the replication process , files are getting
>> generated in
>> > $PGDATA/base directory. Some of the file end up with _fsm and some _vm.
>>
>> The *_fsm files are used for a relation's Free Space Map, which tracks
>> ... free space in the relation (tuples/pages which are known dead and
>> re-usable).  The *_vm files store the Visibility Map, which is a list
>> of pages containing only tuples visible to all transactions.  They're
>> generated and used by Postgres' autovacuum daemon.  Like the *.1, *.2
>> ... *.N files that Postgres creates to partition tables' disk files at
>> one gbyte boundaries, you'll want to leave them alone.
>>
>> See sections 53.3 and 53.4 of TFM for 8.4 for further details.
>>
>> rls
>>
>> --
>> :wq
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100305/d22529a7/attachment.html