Re: support for MERGE
От
Álvaro Herrera
Тема
Re: support for MERGE
Дата
Msg-id
202203091744.o27bb2gpex2j@alvherre.pgsql
Ответ на
Re: support for MERGE (Zhihong Yu)
Список
Дерево обсуждения
support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Simon Riggs <simon.riggs@enterprisedb.com>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Vik Fearing <vik@postgresfriends.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Daniel Westermann <dwe@dbi-services.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Andres Freund <andres@anarazel.de>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tom Lane <tgl@sss.pgh.pa.us>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
Re: support for MERGE Julien Rouhaud <rjuju123@gmail.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Simon Riggs <simon.riggs@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Should use MERGE use BulkInsertState ? Justin Pryzby <pryzby@telsasoft.com>
Re: Should use MERGE use BulkInsertState ? Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Should use MERGE use BulkInsertState ? Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Erik Rijkers <er@xs4all.nl>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Robert Haas <robertmhaas@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE David Steele <david@pgmasters.net>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE David Steele <david@pgmasters.net>
Re: support for MERGE Bruce Momjian <bruce@momjian.us>
Re: support for MERGE Magnus Hagander <magnus@hagander.net>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Magnus Hagander <magnus@hagander.net>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
On 2022-Mar-07, Zhihong Yu wrote: > For v13-0003-MERGE-SQL-Command-following-SQL-2016.patch : > > + * Reset per-tuple memory context to free any expression evaluation > + * storage allocated in the previous cycle. > + */ > + ResetExprContext(econtext); > > Why is the memory cleanup done in the next cycle ? Can the cleanup be done > at the end of the current cycle ? I have removed that, because Andres had already pointed out that it was redundant with the reset done in the caller. > + * XXX Should this explain why MERGE has the same logic as UPDATE? > > I think explanation should be given. Actually, the routine in question is only handling insert, not UPDATE, so MERGE is not relevant to the function. I have removed the comment. This was probably a leftover from work prior to 86dc90056dfd; that commit made it all irrelevant. -- Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/ "Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)
В списке pgsql-hackers по дате отправления
От: Magnus Hagander
Дата: