Status of PostgreSQL for 4+ processors

Started by Benjamin Araialmost 21 years ago2 messages
#1Benjamin Arai
barai@cs.ucr.edu

I have been trying to find information on PostgreSQL for running it on
greater then 4 processors. Are there any benchmarks out there and have
there been any problems or does anybody forsee any issues running
PostgreSQL with more then 4 processors?

Benjamin

#2Neil Conway
neilc@samurai.com
In reply to: Benjamin Arai (#1)
Re: Status of PostgreSQL for 4+ processors

Benjamin Arai wrote:

I have been trying to find information on PostgreSQL for running it on
greater then 4 processors. Are there any benchmarks out there and have
there been any problems or does anybody forsee any issues running
PostgreSQL with more then 4 processors?

There shouldn't be any issues with running on large SMP machines. There
has been some speculation that lock contention (specifically for the
BufMgrLock) might hurt performance somewhat on machines with > 4
processors, but I don't know to what degree. In any case, you should
certainly be able to *use* PG; how well it will perform on a many-way
SMP box relative to, say, Oracle, I'm not sure.

-Neil