| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Brian Ghidinelli <brian(at)pukkasoft(dot)com> |
| Cc: | SF Postgres <sfpug(at)postgresql(dot)org> |
| Subject: | Re: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB |
| Date: | 2011-01-21 05:37:49 |
| Message-ID: | 4D391BAD.2050306@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
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.
http://www.pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Ghidinelli | 2011-01-24 20:57:26 | Re: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB |
| Previous Message | Brian Ghidinelli | 2011-01-12 19:56:58 | Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB |