Re: bind variables, soft vs hard parse

Поиск
Список
Период
Сортировка
От Marcus Engene
Тема Re: bind variables, soft vs hard parse
Дата
Msg-id 43822AA9.1000900@engene.se
обсуждение исходный текст
Ответ на bind variables, soft vs hard parse  (Marcus Engene <mengpg@engene.se>)
Ответы Re: bind variables, soft vs hard parse  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
Jim C. Nasby wrote:
> It might be more useful to look at caching only planning and not
> parsing. I'm not familiar with the output of the parsing stage, but
> perhaps that could be hashed to use as a lookup into a cache of planned
> queries. I suspect that would remove issues of different search_paths.

A really stupid question, in the cached query-string, wouldn't it be
possible to add the env specifics? Ie the string to check against is
something like

search_paths=...\n
SELECT ...

Or would there be too much stuff to append/prepend?

Best regards,
Marcus




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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: why is gist index taking so much space on the disc
Следующее
От: Bob Ippolito
Дата:
Сообщение: PostgreSQL 8.1.0 catalog corruption