Josh Berkus <josh@agliodbs.com> writes:
> Juan,
>> When I hit
>> this pgsql on this laptop with a large query I can see the load spike up
>> really high on both of my virtual processors. Whatever, pgsql is doing
>> it looks like both cpu's are being used indepently.
> Nope, sorry, you're being decieved. Postgres is strictly one process, one
> query.
This is not strictly true: we have for instance pushed off some work
into a "background writer" process, and even just having both a client
and a server process active allows some small amount of parallelism.
But you're certainly not going to see effective use of more than about
two CPUs on a single query stream ... at least not without Bizgres or
some other add-on.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
