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

Re: Multi-processors

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "c k" <shreeseva(dot)learning(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Multi-processors
Date: 2008-09-19 13:52:18
Message-ID: 48D36842.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> "c k" <shreeseva(dot)learning(at)gmail(dot)com> 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 normal mix it uses all processors.
 
> What are the limitations on using multiple processors/cores and main
> memory?
 
I'm not sure what you're getting at here, but PostgreSQL goes through
the file system, so OS caching (which is what usually happens to
otherwise unused system RAM) benefits PostgreSQL.  Does that help?
 
-Kevin

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-09-19 14:29:32
Subject: Re: Multi-processors
Previous:From: Mikel LindsaarDate: 2008-09-19 13:37:03
Subject: Re: unable to restore 8.2.5

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