Re: Catching up Production from Warm Standbyaftermaintenance - Please help

From: Lewis Kapell <lkapell(at)setonhome(dot)org>
To: Scott Whitney <swhitney(at)journyx(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Catching up Production from Warm Standbyaftermaintenance - Please help
Date: 2009-07-07 17:46:10
Message-ID: 4A5389E2.8010909@setonhome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2009-07-07 17:50:40 Re: Catching up Production from Warm Standby aftermaintenance - Please help
Previous Message Jennifer Spencer 2009-07-07 17:40:05 Re: Catching up Production from Warm Standby aftermaintenance - Please help