Re: User-facing aspects of serializable transactions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: User-facing aspects of serializable transactions
Дата
Msg-id 23417.1243475359@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: User-facing aspects of serializable transactions  (Greg Stark <greg.stark@enterprisedb.com>)
Ответы Re: User-facing aspects of serializable transactions  (Greg Stark <greg.stark@enterprisedb.com>)
Re: User-facing aspects of serializable transactions  (Robert Haas <robertmhaas@gmail.com>)
Re: User-facing aspects of serializable transactions  (Peter Eisentraut <peter_e@gmx.net>)
Re: User-facing aspects of serializable transactions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Greg Stark <greg.stark@enterprisedb.com> writes:
> Without any real way to represent predicates this is all pie in the  
> sky. The reason we don't have predicate locking is because of this  
> problem which it sounds like we're no closer to solving.

Yeah.  The fundamental problem with all the "practical" approaches I've
heard of is that they only work for a subset of possible predicates
(possible WHERE clauses).  The idea that you get true serializability
only if your queries are phrased just so is ... icky.  So icky that
it doesn't sound like an improvement over what we have.
        regards, tom lane


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: survey of WAL blocksize changes
Следующее
От: andy
Дата:
Сообщение: sun blade 1000 donation