Re: pg_migrator and an 8.3-compatible tsvector data type - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_migrator and an 8.3-compatible tsvector data type
Date
Msg-id 4A1F399A.8010609@dunslane.net
Whole thread Raw
In response to Re: pg_migrator and an 8.3-compatible tsvector data type  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Caleb Welton
Date:
Subject: Re: Python 3.0 does not work with PL/Python
Next
From: Bruce Momjian
Date:
Subject: Re: bytea vs. pg_dump