Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers
Дата
Msg-id 87mzfhl2g1.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers  ("Jojo Paderes" <jojo.paderes@gmail.com>)
Список pgsql-performance
jojo.paderes@gmail.com ("Jojo Paderes") wrote:
> I'd like to know if the latest PostgreSQL release can scale up by
> utilizing multiple cpu or dual core cpu to boost up the sql
> executions.
>
> I already do a research on the PostgreSQL mailing archives and only
> found old threads dating back 2000. A lot of things have improved with
> PostgreSQL and hopefully the support for multiple cpu or dual cores is
> already provided.

If you submit multiple concurrent queries, they can be concurrently
processed on separate CPUs; that has long been supported, and people
have been using SMP systems to this end for years.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/spreadsheets.html
"In other words  -- and this is the rock solid  principle on which the
whole  of the Corporation's  Galaxy-wide success  is founded  -- their
fundamental design  flaws are  completely hidden by  their superficial
design flaws." -- HHGTG

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Indexes with descending date columns
Следующее
От: Bendik Rognlien Johansen
Дата:
Сообщение: Problem with query, forget previous message