Thanks. Yes, an option. Was considering that as well.
Joe
> On Jun 2, 2023, at 9:41 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> 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