Re: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB

On 1/20/2011 9:37 PM, Josh Berkus wrote:
> 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.

Thanks Josh! I took a look at Greg Smith's tuning page on the wiki as
well and made some additional changes. I think we have a good starting
point.

>> 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?

Archive directory for hot_standby. I just ran a handful of pgbench
tests, my checkpoint_segments is set to 10 and there are 338 16MB files
in the hot_standby directory. Normal?

Brian

PS - there is "no replacement for displacement" as they say in the
motorsport world - pgbench on new hardware has 14x the TPS!