COPY performance vs insert

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: colinthart(at)gmail(dot)com
Subject: COPY performance vs insert
Date: 2020-02-12 09:25:05
Message-ID: 158149950563.1204.12282341954153208338@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/populate.html
Description:

I think this could be clearer. In particular, performance of COPY vs INSERT
from a query (INSERT INTO ... SELECT FROM ...) or INSERT with a list of rows
(INSERT INTO ... VALUES (), (), (), ...)
Is there any performance benefit with COPY in those cases?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Andrus 2020-02-12 10:06:56 Re: How to restore roles without changing postgres password
Previous Message Andrus 2020-02-12 07:31:48 Re: How to restore roles without changing postgres password