Skip site navigation (1) Skip section navigation (2)

Re: How many threads/cores Postgres can utilise?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How many threads/cores Postgres can utilise?
Date: 2010-04-30 14:17:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Greg Smith wrote:
> Piotr Kublicki wrote:
> > 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.
> The database will use as many cores as you have available, so long as 
> you have multiple simultaneous queries to keep each of them busy--no 
> single query will use more than one core.  In practice, on a VM install 
> you may discover you're limited by either I/O rate or VM overhead long 
> before you reach the scalability limits of the database though.

I thought we had an FAQ item on this topic, but it seems it was removed
or was never there.  :-(

I have added one:

I also added information to the FAQ about focusing on I/O and memory
issues before CPU:

  Bruce Momjian  <bruce(at)momjian(dot)us>

In response to

pgsql-general by date

Next:From: David FetterDate: 2010-04-30 14:30:44
Subject: Re: Inheritance efficiency
Previous:From: Ing. Yunior Mesa ReyesDate: 2010-04-30 14:10:10
Subject: Nuevo sobre PGday Latinoamericano 2011...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group