Re: Is Posgresql and Interchange multithreaded?

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