Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

In response to

Responses

sfpug by date

Next:From: Brian GhidinelliDate: 2011-01-24 20:57:26
Subject: Re: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB
Previous:From: Brian GhidinelliDate: 2011-01-12 19:56:58
Subject: Starting point for upsizing 8.3 -> 9.0 and 6GB -> 16GB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group