On 28/04/10 17:15, Piotr Kublicki wrote: > > > > Dears, > > 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 is good at using multiple cores for multiple concurrent queries/clients, but is almost completely incapable of using multiple cores to speed up single big queries. If your workload is "lots and lots of simpler queries" then you want many cores. If you workload is a few big complex queries, you want fewer cores but very fast ones. About the only benefit that a single big query gets from spare cores is that the OS can do some other housekeeping work using the other core(s). -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
