Postgres Pro
Downloads
Home   >   mailing lists

Thread: newbie question

newbie question

From
Heine Ferreira
Date:
Hi

Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows?

Thanks

H.F.

Re: newbie question

From
Chris Curvey
Date:
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira <heine.ferreira@gmail.com> wrote:
Hi

Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows?

Thanks

H.F.


It certainly looks like it on my machine!  As far as my Linux box can tell, the "hyperthreaded" CPUs just appear to be additional CPUs.  So even though I only have four physical CPUs in my box, Linux thinks I have eight.



--
e-Mail is the equivalent of a postcard written in pencil.  This message may not have been sent by me, or intended for you.  It may have been read or even modified while in transit.  e-Mail disclaimers have the same force in law as a note passed in study hall.  If your corporate attorney says that you need an disclaimer in your signature, you need a new corporate attorney.

Re: newbie question

From
Dann Corbit
Date:

PostgreSQL is process based.  So it can be configured to use resources as intensively as you like.

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Heine Ferreira
Sent: Monday, June 06, 2011 1:17 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] newbie question

 

Hi

Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows?

Thanks

H.F.

Re: newbie question

From
Craig Ringer
Date:
On 06/07/2011 04:17 AM, Heine Ferreira wrote:
> Hi
>
> Does Postgresql utilize hyperthreading and multiple cores on the
> relevant processors on windows?

Sort-of. PostgreSQL runs many processes, one per query. Each process has
a single thread. This means that one query can use at most one CPU core,
but many queries running concurrently can use many cpu cores.

For future posts, please choose a more informative subject line. Many
people will ignore posts entitled "help," "question," etc.

--
Craig Ringer