Re: Autovacuum help.. - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Autovacuum help..
Date
Msg-id cone.1154878879.713281.31808.1000@zoraida.natserv.net
Whole thread Raw
In response to Autovacuum help..  (Sundar Narayanaswamy <sundar007@yahoo.com>)
Responses Re: Autovacuum help..
List pgsql-general
Matthew T. O'Connor writes:

> In many instances the default thresholds for autovacuum are too
> conservative.  You can try making it more aggressive and see what
> happens, you can do this generally, or on a table specific basis.

I think something is very wrong with the estimates I am getting back. After
3 times increasing the max_fsm_pages, every time I get the same error..
about needing to increase max_fsm_pages.. and always the error is
recommending exactly the same number of additional fsm_pages.

I see other threads with other people having simmilar problems. Going to see
if I can find a resolution in the archives.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling and enabling constraints and triggers to make pg_restore work
Next
From: Chris
Date:
Subject: Re: error initing db