pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql on Quad CPU machine
2+ messages / 2 participants
[nested] [flat]
* Postgresql on Quad CPU machine
@ 2004-01-11 15:53 D. Dante Lorenso <dante@lorenso.com>
2004-01-11 16:07 ` Re: Postgresql on Quad CPU machine Doug McNaught <doug@mcnaught.org>
0 siblings, 1 reply; 2+ messages in thread
From: D. Dante Lorenso @ 2004-01-11 15:53 UTC (permalink / raw)
To: pgsql-performance
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?
I'm not running a high load on that machine yet, So I can't tell
if the load is being balanced across the CPUs. I expect that as
some of the newly launched sites grow it will require more resources
but maybe some of you could share your results of this type of
deployment setup.
Dante
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgresql on Quad CPU machine
2004-01-11 15:53 Postgresql on Quad CPU machine D. Dante Lorenso <dante@lorenso.com>
@ 2004-01-11 16:07 ` Doug McNaught <doug@mcnaught.org>
0 siblings, 0 replies; 2+ messages in thread
From: Doug McNaught @ 2004-01-11 16:07 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-11 16:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-11 15:53 Postgresql on Quad CPU machine D. Dante Lorenso <dante@lorenso.com>
2004-01-11 16:07 ` Doug McNaught <doug@mcnaught.org>
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