Re: How many threads/cores Postgres can utilise?

On Wed, Apr 28, 2010 at 5:15 AM, Piotr Kublicki <Piotr(dot)Kublicki(at)iop(dot)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