Postgres Pro
Downloads
Home   >   mailing lists

Re: custom background worker task for \copy? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: custom background worker task for \copy?
Date
Msg-id bfd97a7d53a7b6dbeace230648054404666fc23d.camel@cybertec.at
Whole thread Raw
In response to custom background worker task for \copy?  (Joe Carlson <jwcarlson@lbl.gov>)
Responses Re: custom background worker task for \copy?
List pgsql-general
Tree view 
On Fri, 2023-06-02 at 11:36 -0700, Joe Carlson wrote:
> I have SQL that does it with \copy (select * from <table> where…) … And that is fine.
> But it would be nice to be able to run the \copy commands in parallel.
> So I was thinking of writing a background worker.

Why don't you go the easy way of using several database connections to run the
parallel COPY statements?

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade and schema complexity...
Next
From: Andrus
Date:
Subject: How to remove user specific grant and revoke