Re: Caching of Queries

Поиск
Список
Период
Сортировка
От Gary Doades
Тема Re: Caching of Queries
Дата
Msg-id 41527CEB.18344.26EF6F28@localhost
обсуждение исходный текст
Ответ на Re: Caching of Queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On 22 Sep 2004 at 15:59, Tom Lane wrote:

> Scott Kirkwood <scottakirkwood@gmail.com> writes:
> > What do you think?
>
> I think this would allow the problems of cached plans to bite
> applications that were previously not subject to them :-(.
> An app that wants plan re-use can use PREPARE to identify the
> queries that are going to be re-executed.
>
>             regards, tom lane
>

And then there are the people that would like to upgrade and get a
performance gain without having to change their programs. A simple
conf flag could turn query/plan caching off for all those that rely on each
statement being re-planned.

This is where SQLServer etc. tend to get big wins. I know from direct
comparisons that SQLServer often takes quite a bit longer to parse/plan
a select statement than Postgres, but wins out overall from its
query/plan caching.

Regards,
Gary.


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: O_DIRECT setting
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Caching of Queries