Doug McNaught wrote:
[EMAIL PROTECTED] (James Thornton) writes:
Is Postgres always one process per client, or can it spawn additional
processes to parallelise some operations such as a nested loops join
operation?
One process per client connection. Right now there is no spawning of
additional "w
[EMAIL PROTECTED] (James Thornton) writes:
> I want to understand how Postgres organizes data and handles IO
> operations so that I will better know how to optimize a Postgres
> database server. I am looking for answers to specific questions and
> pointers to where this stuff is documented.
If yo
I want to understand how Postgres organizes data and handles IO
operations so that I will better know how to optimize a Postgres
database server. I am looking for answers to specific questions and
pointers to where this stuff is documented.
How does Postgres organize its data? For example, is it g
