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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2007-01-18 14:05:28 Re: Vacuum v/s Autovacuum
Previous Message Michael Glaesemann 2007-01-18 13:31:10 Re: Vacuum v/s Autovacuum