Re: PostgreSQL on Dual Processors, Dual-Core AMD Chips

On Tue, 2005-10-18 at 16:35, Onyx wrote:
> Hello Everyone,
> Does anyone know if PostgreSQL supports running on dual processors,
> and will efficiently utilize the dual processors for performance?
> More specifically, will PostgreSQL utilize the dual processor
> performance of using dual-core AMD chips? Any information would be
> helpful...

Yes. As long as it's on an OS that supports SMP, PostgreSQL can use >1
CPU. However, it each process can only use ONE CPU at at time, so if
you only are running batch files or other single user type things, then
the second CPU may not be as much use. OTOH, only certain data
warehouse queries could really benefit from spreading a single query
across multiple processors, so it's not a big deal for 95% of all
postgresql installs.

Note that there's usually plenty for the OS to do, so even in the case
of datawarehousing, the second CPU often makes a marked difference in
performance.