Re: pg_restore causing deadlocks on partitioned tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_restore causing deadlocks on partitioned tables
Дата
Msg-id 1749638.1600281641@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_restore causing deadlocks on partitioned tables  (Amit Langote <amitlangote09@gmail.com>)
Ответы RE: pg_restore causing deadlocks on partitioned tables
Re: pg_restore causing deadlocks on partitioned tables
Список pgsql-hackers
Amit Langote <amitlangote09@gmail.com> writes:
> Updated patch attached.

Pushed with a little bit of fooling about.  After looking at the
git history, I saw that the Assert we were wondering about used to
be just "Assert(constr)", and there were not run-time checks on
whether constr is null.  That was changed when f0e44751d added
partition constraint checking into ExecConstraints' responsibilities.
At some later point that code was removed from ExecConstraints,
but we failed to undo the other changes in ExecConstraints, leaving
it looking pretty silly.  So I reverted this to the way it was,
with just an Assert and no regular checks.

I also did a bit more work on the comments.  (Speaking of which,
is there a better place to put the commentary you removed from
InitResultRelInfo?  It was surely wildly out of place there,
but I'm wondering if maybe we have a README that should cover it.)

I pushed this to HEAD only, and the other patch as far back as
v12, so we will have a solution to the deadlock problem in v12.

            regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: recovering from "found xmin ... from before relfrozenxid ..."
Следующее
От: Tom Lane
Дата:
Сообщение: Re: recovering from "found xmin ... from before relfrozenxid ..."