Re: [PATCH] Caching for stable expressions with constant arguments v3
От | Marti Raudsepp |
---|---|
Тема | Re: [PATCH] Caching for stable expressions with constant arguments v3 |
Дата | |
Msg-id | CABRT9RDJiQKcbbYWzykVFiacDv9nBxzBJGSDLPMqVe5ohiSi2g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [PATCH] Caching for stable expressions with constant arguments v3 (Marti Raudsepp <marti@juffo.org>) |
Ответы |
Re: [PATCH] Caching for stable expressions with constant arguments v3
Re: [PATCH] Caching for stable expressions with constant arguments v3 |
Список | pgsql-hackers |
On Wed, Dec 7, 2011 at 00:29, Marti Raudsepp <marti@juffo.org> wrote: > ExecInitExpr enables the cache when its 'PlanState *parent' attribute > isn't NULL [...] > On the other hand, a few places lose caching support this way since > they don't go through the planner: > * Column defaults in a COPY FROM operation. Common use case is > 'timestamp default now()' > This might be a significant loss in some data-loading scenarios. > * ALTER TABLE t ALTER col TYPE x USING some_expr(); No big loss here. Let me rephrase that as a question: Does it seem worthwhile to add a new argument to ExecInitExpr to handle those two cases? Does relying on the PlanState argument being NULL seem like a bad idea for any reason? PS: I forgot to mention that 2 test cases covering the two above query types are deliberately left failing in the v4-wip patch. Regards, Marti
В списке pgsql-hackers по дате отправления: