Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Дата
Msg-id AANLkTi=nXWxQaeMteVLBu5d6_ujW7asJKhTzeqOV8on2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Rewrite, normal execution vs. EXPLAIN ANALYZE  (David Fetter <david@fetter.org>)
Список pgsql-hackers
On Fri, Jul 23, 2010 at 3:31 PM, David Fetter <david@fetter.org> wrote:
> On Fri, Jul 23, 2010 at 03:30:03PM -0400, Robert Haas wrote:
>> On Fri, Jul 23, 2010 at 3:19 PM, Marko Tiikkaja
>> <marko.tiikkaja@cs.helsinki.fi> wrote:
>> > This may be a bit hard to follow, but essentially what happens is
>> > that in EXPLAIN ANALYZE, the INSERT in the rule does not see the
>> > changes made by T2 to baz while in the regular execution scenario
>> > it does.
>>
>> Well that's gotta be a bug, but in what I'm not sure.
>
> I've said it before, and I'll say it again.  User-accessible RULEs are
> themselves a bug :P

Maybe so, but perhaps it would be more productive to concentrate on
solving the immediate problem first.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: bg worker: overview