Re: One vacuum full is not enough.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hannu Krosing wrote:
> Ü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.
> 

Is not this the case:

max_fsm_pages                  | 2000000max_fsm_relations              | 1000

and when I was doing the vacuum full these settings were above the
real needs.



Regards
Gaetano Mendola




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCMA++7UpzwH2SGd4RAi0hAJwLBpSWlDTQoAWglK8Dg/IoY3fb8QCfTjKU
wxDSc2VG7B5pRPfCfQqxRtk=
=Ce+9
-----END PGP SIGNATURE-----