Re: why postgresql over other RDBMS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why postgresql over other RDBMS
Дата
Msg-id 3692.1180196259@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: why postgresql over other RDBMS  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: why postgresql over other RDBMS  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Re: why postgresql over other RDBMS  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-general
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> Tom Lane wrote:
>> A more interesting question is what sort of hardware you need for that
>> actually to be a win, though.  Loading a few tables in parallel sounds
>> like an ideal recipe for oversaturating your disk bandwidth...

> you don't actually need that much of disk bandwidth both COPY and CREATE
> INDEX are CPU bottlenecked on modern boxes and reasonable disk
> subsystems - spreading their work over multiple cores/processes can give
> big benefits.

Hmm ... I wonder if that's true for COPY BINARY ...

            regards, tom lane

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: backup strategies
Следующее
От: "Richard P. Welty"
Дата:
Сообщение: Re: backup strategies