From: Tom Lane <tgl@sss.pgh.pa.us>
To: Qing Zhao <qzhao@quotefx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: possible improvement between G4 and G5
Date: Tue, 06 Apr 2004 01:47:22 -0400
Message-ID: <19781.1081230442@sss.pgh.pa.us> (raw)
In-Reply-To: <DDB7CC31-8764-11D8-9AA6-000A95AB8896@quotefx.net>
References: <009901c41b48$8357c860$2500fa0a@CardServices.TCI.com>
<DDB7CC31-8764-11D8-9AA6-000A95AB8896@quotefx.net>
Qing Zhao <qzhao@quotefx.net> writes:
> We have got a G5 64-bit processor to replace an old G4 32-bit
> processor. Given everything else equal, should we see a big
> improvement on PG's performance?
Nope. Database performance typically depends on disk performance first,
and RAM size second. A 64-bit processor might help by allowing you to
install more RAM, but you didn't say that you had.
> The other question I have is that, when I tried different size for
> shared_buffer ( i used 10,000, 1,000, 528, 256) and Max
> connections=32, it gives me error when I tried to start PG using
> pg_ctl start as postgres. It kept saying this is bigger than the
> system Shared Memory.
Out-of-the-box, Mac OS X has a very low SHMMAX limit. See the PG admin
docs or the mail list archives about how to increase it. You should do
this --- most people find that you want to set shared_buffers to 1000 or
10000 or so for best performance.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, qzhao@quotefx.net
Subject: Re: possible improvement between G4 and G5
In-Reply-To: <19781.1081230442@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox