Thread: Is Posgresql and Interchange multithreaded?
Is Postgresql multithreaded i.e can it take advantange of multiprocessor systems (4 ways)? Is Interchange written as multithreaded application? What is the most processors you have seen Postgresql running on? Jeff
Gill, Jeffrey L writes: > Is Postgresql multithreaded No. > i.e can it take advantange of multiprocessor systems (4 ways)? That doesn't have anything to do with it. > What is the most processors you have seen Postgresql running on? PostgreSQL can use one processor per connection. There's no theoretical limit to that. -- Peter Eisentraut peter_e@gmx.net
Gill, Jeffrey L wrote: > Is Postgresql multithreaded i.e can it take advantange of multiprocessor > systems (4 ways)? PostgreSQL is a multi-process application, meaning each connection to the database gets it's own process. So if the operating system schedules the processes on different processors, then they will run truly parallel which will be faster than if you had just one processor. But if you're just doing one connection at a time, no, you won't see any speedup. You can't have multiple processors working on the same query, for example. > Is Interchange written as multithreaded application? Don't know what that is. > What is the most processors you have seen Postgresql running on? One. :) --Jeremy
At 10:56 AM 4/1/2002 , Gill, Jeffrey L wrote:
>Is Postgresql multithreaded i.e can it take advantange of multiprocessor
>systems (4 ways)?
Not presactly multithreaded, but since every connection to the database
gets its own backend process, PostgreSQL will make use of multi processors
as long as there are multiple clients.
-crl
--
Chad R. Larson (CRL22) chad@eldocomp.com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228
"Gill, Jeffrey L" <jeffrey.l.gill@intel.com> wrote:
> Is Postgresql multithreaded i.e can it take advantange of multiprocessor
> systems (4 ways)? Is Interchange written as multithreaded application?
> What is the most processors you have seen Postgresql running on?
Our server is a Dell with 4 processors.
Ciao
Gaetano
--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");