possible improvement between G4 and G5 - Mailing list pgsql-performance

From Qing Zhao
Subject possible improvement between G4 and G5
Date
Msg-id DDB7CC31-8764-11D8-9AA6-000A95AB8896@quotefx.net
Whole thread Raw
In response to Re: atrocious update performance  ("Rosser Schwarz" <rschwarz@totalcardinc.com>)
Responses Re: possible improvement between G4 and G5
List pgsql-performance
Hi,

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?

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.  So finally
I started PG using SystemStarter start PostgreSQL and it seems starting
OK. Any idea?


Thanks a lot!

Qing Zhao


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: atrocious update performance
Next
From: Stephan Szabo
Date:
Subject: Re: atrocious update performance