Re: foreign key locks

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: foreign key locks
Дата
Msg-id 20121116161747.GC4454@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: foreign key locks  (Noah Misch <noah@leadboat.com>)
Ответы Re: foreign key locks  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Noah Misch wrote:
> On Wed, Nov 14, 2012 at 01:27:26PM -0300, Alvaro Herrera wrote:
> > https://github.com/alvherre/postgres/commit/df2847e38198e99f57e52490e1e9391ebb70d770
> >
> > (I don't think this is worth a v24 submission).
>
> Are you aware of any defects in or unanswered questions of this version that
> would stall your commit thereof?

Yeah, I am revisiting the list of XXX/FIXME comments you pointed out
previously.

And I would still like someone with EPQ understanding to review the
ExecLockRows / EvalPlanQual / heap_lock_tuple interactions.

Andres is on the verge of convincing me that we need to support
singleton FOR SHARE without multixacts due to performance concerns.  It
would be useful for more people to chime in here: is FOR SHARE an
important case to cater for?  I wonder if using FOR KEY SHARE (keep
performance characteristics, but would need to revise application code)
would satisfy Andres' users, for example.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: another idea for changing global configuration settings from SQL
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Materialized views WIP patch