Should use MERGE use BulkInsertState ? - Mailing list pgsql-hackers

From Justin Pryzby
Subject Should use MERGE use BulkInsertState ?
Date
Msg-id 20220511125148.GK19626@telsasoft.com
Whole thread Raw
In response to Re: support for MERGE  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Should use MERGE use BulkInsertState ?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Should it use it ?

It occured to me to ask when reading Bruce's release notes, which say:
| [MERGE] is similar to INSERT ... ON CONFLICT but more batch-oriented.

Currently, INSERT *never* uses bistate - even INSERT SELECT.

INSERTing 10k tuples will dirty 10k buffers - not limited to the size of a
strategy/ring buffer.  Currently, MERGE will do the same.

I had a patch for INSERT last year.
https://commitfest.postgresql.org/35/2553/



pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: First draft of the PG 15 release notes
Next
From: Masahiko Sawada
Date:
Subject: Re: Support logical replication of DDLs