Re: pg_dump additional options for performance - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: pg_dump additional options for performance
Date
Msg-id 488D07E0.4020303@dunslane.net
Whole thread Raw
In response to Re: pg_dump additional options for performance  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_dump additional options for performance  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-patches

Joshua D. Drake wrote:
>
> Agreed but that is a problem I understand with a solution I don't. I
> am all eyes on a way to fix that. One thought I had and please, be
> gentle in response was some sort of async transaction capability. I
> know that libpq has the ability to send async queries. Is it possible
> to do this:
>
> send async(copy table to foo)
> send async(copy table to bar)
> send async(copy table to baz)
>
> Where all three copies are happening in the background?
>
>

IIRC, libpq doesn't let you have more than one async query active at one
time.

cheers

andrew

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pg_dump additional options for performance
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump additional options for performance