Re: Catching up Production from Warm Standbyaftermaintenance - Please help - Mailing list pgsql-admin

From Lewis Kapell
Subject Re: Catching up Production from Warm Standbyaftermaintenance - Please help
Date
Msg-id 4A5389E2.8010909@setonhome.org
Whole thread Raw
In response to Re: Catching up Production from Warm Standbyaftermaintenance - Please help  ("Scott Whitney" <swhitney@journyx.com>)
Responses Re: Catching up Production from Warm Standbyaftermaintenance - Please help  (Scott Mead <scott.lists@enterprisedb.com>)
List pgsql-admin
Scott Whitney wrote:
> max_fsm_pages = 1500000                 # min max_fsm_relations*16, 6 bytes
> each
> max_fsm_relations = 70000               # min 100, ~70 bytes each
>
> It's quite possible that those settings are too low, but I've honestly no
> idea how to estimate these other than trial and error. I've not had the time
> to really brush up on that level of tuning.
>

If you were planning to upgrade to 8.4 in the near future, then you
wouldn't have to worry about these settings any more.  Those settings
tune themselves and they are no longer specified in the configuration file.

Lewis Kapell


pgsql-admin by date:

Previous
From: Jennifer Spencer
Date:
Subject: Re: Catching up Production from Warm Standby aftermaintenance - Please help
Next
From: Scott Mead
Date:
Subject: Re: Catching up Production from Warm Standby aftermaintenance - Please help