Re: One vacuum full is not enough. - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: One vacuum full is not enough.
Date
Msg-id 1110386371.5518.2.camel@fuji.krosing.net
Whole thread Raw
In response to One vacuum full is not enough.  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: One vacuum full is not enough.
List 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@tm.ee>


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: fool-toleranced optimizer
Next
From: Oleg Bartunov
Date:
Subject: pgpool question