| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Faster data load |
| Date: | 2024-09-09 07:25:43 |
| Message-ID: | CAFCRh-9hS7sndSvqsC_EomtuO1aAym5Dwv7PigRZAYqSmx2TkQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Sep 8, 2024 at 8:27 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> > simple INSERT ... SELECT was more than twice as fast as 8 parallel COPY
> > operations (and about 8 times as fast as a single COPY).
>
> Yeah they seem to have changed a great deal. Though you are correct in
> saying COPY is not faster then INSERT..SELECT
Interesting. Thanks for sharing. Although to be fair, that adds CSV parsing
to the mix, something INSERT-FROM-SELECT does not have to do,
skewing the results a little maybe. Comparing against COPY BINARY
would be fairer, but less practical I guess. --DD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 2024-09-09 07:53:37 | Connection between PostgreSQL and SAP HANA database | |
| Previous Message | Adrian Klaver | 2024-09-08 20:46:34 | Re: postgresql FDW vs dblink for DDL |