Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum v/s Autovacuum - Mailing list pgsql-performance

From Gauri Kanekar
Subject Re: Vacuum v/s Autovacuum
Date
Msg-id 7e4ba9550701180546u38609442ic5103a834f7b7d0d@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum v/s Autovacuum  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Vacuum v/s Autovacuum
List pgsql-performance
Tree view
Hi
 
Thanks.
 
We have autovacuum ON , but still postgres server warns to increas max_fsm_pages value.
 
Do autovacuum release space after it is over?
 
so how can we tackle it.
 


 
On 1/18/07, Michael Glaesemann <grzm@seespotcode.net> wrote:

On Jan 18, 2007, at 22:24 , Gauri Kanekar wrote:

> is autovacuum similar to vacuum full analyse verbose.

http://www.postgresql.org/docs/8.2/interactive/routine-
vacuuming.html#AUTOVACUUM

Apparently, no FULL, no VERBOSE (which is only really useful if you
want to see the results, not for routine maintenance).


Michael Glaesemann
grzm seespotcode net





--
Regards
Gauri

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Vacuum v/s Autovacuum
Next
From: Bill Moran
Date:
Subject: Re: Vacuum v/s Autovacuum