Re: Question regarding autovacuum

Steve Crawford wrote:
> 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
>
>
Am I correct in that this number will GROW over time? Or is what I see
right now (with everything running ok) all that the system
will ever need?

If the latter, then I'm WELL within limits and I guess I need to tune
the autovacuum parameters to be more aggressive; system views show it IS
being run.

INFO: free space map contains 5895 pages in 639 relations
DETAIL: A total of 14976 page slots are in use (including overhead).
14976 page slots are required to track all free space.
Current limits are: 179200 page slots, 1000 relations, using 1115 kB.

-- Karl Denninger