Re: 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

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(at)eldocomp(dot)com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228

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

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(at)gmx(dot)net

"Gill, Jeffrey L" <jeffrey(dot)l(dot)gill(at)intel(dot)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");