| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Laszlo Fogas" <laszlo(at)falconsocial(dot)com>,<francois(at)teksol(dot)info> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: slowness what only full vacuum can solve |
| Date: | 2012-08-10 21:08:33 |
| Message-ID: | 502532010200002500049588@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Laszlo Fogas <laszlo(at)falconsocial(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2012-08-10 21:56:07 | Re: slowness what only full vacuum can solve |
| Previous Message | jennifer.l.fentress | 2012-08-10 20:03:52 | AUTO: Jennifer L Fentress is out of the office (returning 08/22/2012) |