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: http://wiki.postgresql.org/wiki/FAQ#How_does_PostgreSQL_use_CPU_resources.3F I also added information to the FAQ about focusing on I/O and memory issues before CPU: http://wiki.postgresql.org/wiki/FAQ#What_computer_hardware_should_I_use.3F -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
