Re: pg_migrator and an 8.3-compatible tsvector data type

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pg_migrator and an 8.3-compatible tsvector data type
Дата
Msg-id 4A1F399A.8010609@dunslane.net
обсуждение исходный текст
Ответ на Re: pg_migrator and an 8.3-compatible tsvector data type  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers

Alvaro Herrera wrote:
> Bruce Momjian wrote:
>   
>> Alvaro Herrera wrote:
>>     
>
>   
>>> Why not?  Right now it's single-threaded.  Would it be faster if it ran
>>> several copies in parallel?
>>>       
>> Sure, but that assumes you have parallel I/O channels;  I assume right
>> now it is I/O limited.
>>     
>
> But so does parallel pg_restore, no?
>
>   

Well, no, it assumes you're not saturating your I/O bandwidth, which 
turns out to be the case more often than you might expect, even without 
multiple I/O channels.

cheers

andrew


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

Предыдущее
От: Caleb Welton
Дата:
Сообщение: Re: Python 3.0 does not work with PL/Python
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: bytea vs. pg_dump