Re: Replication Syatem

Gauri Kanekar wrote:
> Andrew,
> 
> Can you explain me in detail why u said vacuum full is making the things
> worst.
> We do vacuum full, as vacuum verbose analyse dont regain space for us.
> 

vacuum full stops all access so that the data files can be re-writen 
without the unused space.

normal vacuum will update the records of what space is no longer used so 
that it can then be reused with the next update/insert. Your db size 
will not shrink straight away but it will stop growing until you use all 
the free space left from previous update/delete

The more frequently you do a normal vacuum the less time it will take 
and things will run a lot smoother with your file size growing slowly to 
accommodate new data.

Expanding on what others have mentioned as a drawback of vacuum full - 
you should look at REINDEX'ing as well (maybe one index or table at a 
time). You will most likely find this will reclaim some disk space for 
you as well.




-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @[EMAIL PROTECTED]
 http://Sheeky.Biz

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance