Re: Sun Fire T2000 and PostgreSQL 8.1.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Sun Fire T2000 and PostgreSQL 8.1.3
Дата
Msg-id 12745.1144275887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Sun Fire T2000 and PostgreSQL 8.1.3  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Sun Fire T2000 and PostgreSQL 8.1.3