pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (9+ messages)  latest in thread

Message-ID: <19781.1081230442@sss.pgh.pa.us>
Permalink:  ../19781.1081230442@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/19781.1081230442@sss.pgh.pa.us

 · 

reply

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