Should use MERGE use BulkInsertState ?

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Should use MERGE use BulkInsertState ?
Дата
Msg-id 20220511125148.GK19626@telsasoft.com
обсуждение исходный текст
Ответ на Re: support for MERGE  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Should use MERGE use BulkInsertState ?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Matthias van de Meent
Дата:
Сообщение: Re: First draft of the PG 15 release notes
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Support logical replication of DDLs