Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Дата
Msg-id 4C4A0E29.5050300@cs.helsinki.fi
обсуждение исходный текст
Ответ на Re: Rewrite, normal execution vs. EXPLAIN ANALYZE  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Rewrite, normal execution vs. EXPLAIN ANALYZE  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On 7/24/10 12:42 AM +0300, Kevin Grittner wrote:
> Alvaro Herrera<alvherre@commandprompt.com>  wrote:
>
>> In short I think a wCTE should only advance the CID, not get a
>> whole new snapshot.
>
> Even after unblocking from a write conflict at the READ COMMITTED
> isolation level?

I'm not sure what you mean by this; UPDATE and DELETE can take a look at 
the new tuple but that's completely separate from the snapshot.



Regards,
Marko Tiikkaja


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

Предыдущее
От: Marko Tiikkaja
Дата:
Сообщение: Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Rewrite, normal execution vs. EXPLAIN ANALYZE