Re: How many threads/cores Postgres can utilise? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: How many threads/cores Postgres can utilise?
Date
Msg-id s2ib42b73151004281051y529bc73cyefc109c5f34dd3d2@mail.gmail.com
Whole thread Raw
In response to How many threads/cores Postgres can utilise?  (Piotr Kublicki <Piotr.Kublicki@iop.org>)
List pgsql-general
On Wed, Apr 28, 2010 at 5:15 AM, Piotr Kublicki <Piotr.Kublicki@iop.org> wrote:
> Sorry to be a royal pain, but I cannot find it anywhere in the
> documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
> We're thinking about installing Postgres on a virtual machine (RedHat 5
> 64-bits), however not sure how many CPUs can be wisely assigned, without
> wasting of resources. Can Postgres utilise multi-core/multi-threaded
> architecture in a reasonably extent?

postgresql will gladly munch on everything you throw at it unless you
are running a single user app.  how many cores to assign has more to
do with the VM technology you are using than anything else.

merlin

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How many threads/cores Postgres can utilise?
Next
From: "Ing. Yunior Mesa Reyes"
Date:
Subject: Sobre PGday Latinoamericano 2011...