Re: slowness what only full vacuum can solve - Mailing list pgsql-general

From Kevin Grittner
Subject Re: slowness what only full vacuum can solve
Date
Msg-id 502532010200002500049588@gw.wicourts.gov
Whole thread Raw
In response to Re: slowness what only full vacuum can solve  (Laszlo Fogas <laszlo@falconsocial.com>)
List pgsql-general
Laszlo Fogas <laszlo@falconsocial.com> wrote:

> Sorry, I wasn't clear.
>
> Autovacuum runs with default setting, I believe it's daily, or
> whenever it feels like.
>
> When autovacuum was disabled, we had this problem once every 2
> months.
>
> With autovacuum enabled, we had this problem once in every six
> month.

That was quite clear.

> It seems autovacuum could only delay the event, but not prevent
> it.

Autovacuum with default settings improves it drastically.
Autovacuum with more aggressive settings might well prevent the
problem entirely.

-Kevin


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: slowness what only full vacuum can solve
Next
From: François Beausoleil
Date:
Subject: Re: slowness what only full vacuum can solve