Re: Postgresql on Quad CPU machine - Mailing list pgsql-performance

From Doug McNaught
Subject Re: Postgresql on Quad CPU machine
Date
Msg-id 87wu7y5v0i.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Postgresql on Quad CPU machine  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-performance
"D. Dante Lorenso" <dante@lorenso.com> writes:

> I'm running PostgreSQL 7.4 on a quad Xeon attached to a
> beefy disk array.  However, I am begining to wonder if this is
> a waste of CPU power.
>
> I think I read somewhere that PostgreSQL is NOT multi-threaded.
> But, will it be able to take advantage of multiple CPUs?  Will
> I have to run separate postmaster instances to get the advantage?

PG uses a separate backend process for each connection, so if you have
multiple simultaneous connections they will use different CPUs.
Single queries will not be split across CPUs.

-Doug

pgsql-performance by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Postgresql on Quad CPU machine
Next
From: "Spiegelberg, Greg"
Date:
Subject: Re: failures on machines using jfs