Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions?

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions?
Дата
Msg-id
20190805074559.GI1740@paquier.xyz
Ответ на
Список
Дерево обсуждения
Ought to use heap_multi_insert() for pg_attribute/depend insertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Thomas Munro <thomas.munro@gmail.com>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Thomas Munro <thomas.munro@gmail.com>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? michael@paquier.xyz
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Michael Paquier <michael@paquier.xyz>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Andres Freund <andres@anarazel.de>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Daniel Gustafsson <daniel@yesql.se>
Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? Andres Freund <andres@anarazel.de>
On Mon, Aug 05, 2019 at 09:20:07AM +0200, Daniel Gustafsson wrote:
> Thanks, the attached v4 updates to patch to handle a0555ddab9b672a046 as well.

+   if (referenced->numrefs == 1)
+       recordDependencyOn(depender, &referenced->refs[0], behavior);
+   else
+       recordMultipleDependencies(depender,
+                                  referenced->refs, referenced->numrefs,
+                                  behavior);
This makes me wonder if we should not just add a shortcut in
recordMultipleDependencies() to use recordDependencyOn if there is
only one reference in the set.  That would save the effort of a multi
insert for all callers of recordMultipleDependencies() this way,
including the future ones.  And that could also be done independently
of the addition of InsertPgAttributeTuples(), no?
--
Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Julien Rouhaud
Дата:
FAQ