Re: [ADMIN] Multi-processors

2008-09-19 Thread Scott Marlowe
On Fri, Sep 19, 2008 at 5:55 AM, c k <[EMAIL PROTECTED]> wrote: > Hello PG Community, > Does PG uses multiple processors/cores if available by default on various > OSes? Yes, see attached top extract from my primary db server at work > What are the limitations on using multiple processors/cores a

Re: [ADMIN] Multi-processors

2008-09-19 Thread Kevin Grittner
>>> "c k" <[EMAIL PROTECTED]> wrote: > Does PG uses multiple processors/cores if available by default on various > OSes? A separate process is created to handle each connection. You don't get much benefit from multiple processors if only one connection at a time is running a query, but in a n