Re: custom background worker task for \copy?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Joe Carlson <jwcarlson(at)lbl(dot)gov>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: custom background worker task for \copy?
Date: 2023-06-03 04:41:22
Message-ID: bfd97a7d53a7b6dbeace230648054404666fc23d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2023-06-03 07:16:54 How to remove user specific grant and revoke
Previous Message Adrian Klaver 2023-06-03 02:22:09 Re: pg_upgrade and schema complexity...