Re: FSM and VM file

On 02/03/10 21:47, akp geek wrote:

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.

my master is 8.3 and slave is 8.4

I'm guessing your slave isn't being vacuumed. Or, perhaps you have a long-running transaction on the slave that is preventing dead rows from being cleaned up.

Two useful commands:

 vacuum verbose mytable;

This will show you how many rows/pages can/should be cleaned up.

 SELECT pg_size_pretty( pg_total_relation_size('mytable') );

This will show you the size of "mytable" (formatted nicely).

--
 Richard Huxton
 Archonet Ltd