Re: why do we need two snapshots per query?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why do we need two snapshots per query?
Дата
Msg-id 12331.1321049099@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: why do we need two snapshots per query?  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: why do we need two snapshots per query?
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> Tom, in that earlier thread you said you'd be doing something in this
> release about that. Can you say more about what that was, and will you
> be doing it still?

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=e6faf910d75027bdce7cd0f2033db4e912592bcc

I think that largely supersedes what I understood your notion of a
one-shot plan to be about, though perhaps I missed something?

I don't think this has a lot to do with what Robert is on about, since
in any situation where a plan is cached for later, we surely are not
going to use the same snapshot to execute it.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: foreign key locks, 2nd attempt
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] VACUUM touching file but not updating relation