Search Postgresql Archives

Re: FSM and VM file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am doing a replication of one of the database and the size of the slave database is growing exponentially . Right now the size of master db is 849M and the slave is 7GB.
 
When I noticed the base directory on the slave , that's when I noticed the fsm and vm files and raised the question.
 
is there any reason why this happens? or is there way to limit the size of the file.
 
my master is 8.3 and slave is 8.4
 
Appreciate your help
 
 
Regards

On Tue, Mar 2, 2010 at 4:29 PM, Scott Mead <scott.lists@xxxxxxxxxxxxxxxx> wrote:
Those are the free space map / visibility map files.  There is going to be one of each for every relation.

  No worries :-) They are supposed to be there:

  http://wiki.postgresql.org/wiki/Segment_Visibility_Map


  Don't clean them up, doing so could be disastrous.  Actually, if I were you, I would avoid doing ANY deletes / purges in the data directory.  Everything in there is maintained by the engine.

--Scott


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux