Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.
Дата
Msg-id 7015.1558548098@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Ответы Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Список pgsql-committers
=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= <fabriziomello@gmail.com> writes:
> Just one doubt, why use LATERAL with pg_get_publication_tables SRF instead
> of JOIN direct to pg_publication_rel?

Yes, LATERAL is just a noise word in this context, but I think
it's good for documentation purposes.

If you're asking why I used a comma instead of JOIN ... ON TRUE,
it's because I don't find the latter to be particularly readable
or good style.  YMMV.

(I agree it's a little weird that the original coding had a mix
of comma and JOIN syntax, but I did not feel a need to revisit
that.)

            regards, tom lane



В списке pgsql-committers по дате отправления:

Предыдущее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: pgsql: Fix O(N^2) performance issue in pg_publication_tables view.