Re: Table refer leak in logical replication

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: Table refer leak in logical replication
Дата
Msg-id CA+HiwqGqxVxwFge7h3SCCfmp4W_DrY7h04Ph5CX1qUwRUbTpCA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table refer leak in logical replication  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Table refer leak in logical replication
Список pgsql-hackers
Thanks for taking a look.

On Tue, Apr 20, 2021 at 2:09 PM Michael Paquier <michael@paquier.xyz> wrote:
> On Mon, Apr 19, 2021 at 09:44:05PM +0900, Amit Langote wrote:
> > Okay, how about the attached then?
>
> create_estate_for_relation() returns an extra resultRelInfo that's
> also saved within es_opened_result_relations.  Wouldn't is be simpler
> to take the first element from es_opened_result_relations instead?
> Okay, that's a nit and you are documenting things in a sufficient way,
> but that just seemed duplicated to me.

Manipulating the contents of es_opened_result_relations directly in
worker.c is admittedly a "hack", which I am reluctant to have other
places participating in.  As originally designed, that list is to
speed up ExecCloseResultRelations(), not as a place to access result
relations from.  The result relations targeted over the course of
execution of a query (update/delete) or a (possibly multi-tuple in the
future) replication apply operation will not be guaranteed to be added
to the list in any particular order, so assuming where a result
relation of interest can be found in the list is bound to be unstable.

--
Amit Langote
EDB: http://www.enterprisedb.com



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

Предыдущее
От: Amul Sul
Дата:
Сообщение: Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Performance degradation of REFRESH MATERIALIZED VIEW