Re: [HACKERS] Cached plans and statement generalization

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Cached plans and statement generalization
Дата
Msg-id 20170425214746.3mngxgbo7yndfgax@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Cached plans and statement generalization  (Doug Doole <ddoole@salesforce.com>)
Ответы Re: [HACKERS] Cached plans and statement generalization
Re: [HACKERS] Cached plans and statement generalization
Список pgsql-hackers
On 2017-04-25 21:11:08 +0000, Doug Doole wrote:
> When I did this in DB2, I didn't use the parser - it was too expensive. I
> just tokenized the statement and used some simple rules to bypass the
> invalid cases. For example, if I saw the tokens "ORDER" and "BY" then I'd
> disallow replacement replacement until I hit the end of the current
> subquery or statement.

How did you manage plan invalidation and such?

- Andres



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [HACKERS] Separation walsender & normal backends
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Separation walsender & normal backends