public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Faster data load
Date: Mon, 9 Sep 2024 09:25:43 +0200
Message-ID: <CAFCRh-9hS7sndSvqsC_EomtuO1aAym5Dwv7PigRZAYqSmx2TkQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAKna9VaVsDzfOfOGu1+grStp9BBHFMKrH5DCEbbtGcQUWJ74KQ@mail.gmail.com>
	<[email protected]>
	<[email protected]>

On Sun, Sep 8, 2024 at 8:27 PM Adrian Klaver <[email protected]> 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

view thread (9+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Faster data load
  In-Reply-To: <CAFCRh-9hS7sndSvqsC_EomtuO1aAym5Dwv7PigRZAYqSmx2TkQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox