Sorry for the lack of response. Things have been busy.
> My thought is to increase shared_buffers to 6144MB, remove
> effective_cache_size and leave the rest?
Effective_cache_size most certainly exists on 9.0.
Also, that s_b seems a bit high for 16GB ram. I'd set it to 4GB.
> Also, we've enabled hot standby on the new 9 server (but don't yet have
> a slave). I noticed that there are ~230 16mb files in the archive
> directory. checkpoint_segments on that box is not set so I would think
> it would be some (much smaller) multiple of 3, no? The hot standby
> directory is basically the same size as the data dir (~5GB).
Archive directory or pg_xlog?
-- Josh Berkus
PostgreSQL Experts Inc.
In response to
sfpug by date
|Next:||From: Brian Ghidinelli||Date: 2011-01-24 20:57:26|
|Subject: Re: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB|
|Previous:||From: Brian Ghidinelli||Date: 2011-01-12 19:56:58|
|Subject: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB|