Re: Question regarding autovacuum

[Karl Denninger <karl@xxxxxxxxxxxxx>]

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