Re: One vacuum full is not enough.

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: One vacuum full is not enough.
Date: 2005-03-09 16:39:31
Message-ID: 1110386371.5518.2.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ühel kenal päeval (teisipäev, 8. märts 2005, 00:52+0100), kirjutas
Gaetano Mendola:
> Hi all,
> running a 7.4.5 it happen to me with another table
> where a single vacuum full was not freeing enough pages,
> here the verbose vacuum full, as you can see only at
> the end: truncated 8504 to 621 pages.
>
> I use pg_autovacuum and it's not enough. I'll schedule
> again a nightly vacuum full.

You may have too few fsm pages, so new inserts/updates don't use all the pages freed by vacuums.

--
Hannu Krosing <hannu(at)tm(dot)ee>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2005-03-09 17:10:25 pgpool question
Previous Message Greg Stark 2005-03-09 15:44:42 Re: fool-toleranced optimizer