newbie question

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.

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.

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