Re: Question regarding autovacuum - Mailing list pgsql-general

From Steve Crawford
Subject Re: Question regarding autovacuum
Date
Msg-id 46D48F8E.4040104@pinpointresearch.com
Whole thread Raw
In response to Re: Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
Responses Re: Question regarding autovacuum  (Karl Denninger <karl@denninger.net>)
List pgsql-general
Karl Denninger wrote:

>> Are your FSM settings enough to keep track of the dead space you have?
>>
> I don't know.  How do I check?

vacuum verbose;

Toward the bottom you will see something like:
...
1200 page slots are required to track all free space.
Current limits are:  453600 page slots, 1000 relations, using 2723 kB.
....

Make sure your current limits have a higher number than the page slots
required.

Cheers,
Steve

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question regarding autovacuum
Next
From: Erik Jones
Date:
Subject: Re: Out of Memory - 8.2.4