Skip site navigation (1) Skip section navigation (2)

Re: Vacuum v/s Autovacuum

From: "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>
To: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum v/s Autovacuum
Date: 2007-01-18 13:46:04
Message-ID: 7e4ba9550701180546u38609442ic5103a834f7b7d0d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)seespotcode(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Bill MoranDate: 2007-01-18 14:05:28
Subject: Re: Vacuum v/s Autovacuum
Previous:From: Michael GlaesemannDate: 2007-01-18 13:31:10
Subject: Re: Vacuum v/s Autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group