Re: Does Postgres 14 have a query cache?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Does Postgres 14 have a query cache?
Дата
Msg-id 06C7D8B6-A577-411A-8754-63D18C6360B4@thebuild.com
обсуждение исходный текст
Ответ на Re: Does Postgres 14 have a query cache?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general

> On Feb 18, 2023, at 06:59, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
> I think the reason
> is that the use case (the exact same query is submitted repeatedly) is
> sufficiently rare that it isn't all that effective in practice.

And, in this use case, a prepared statement is in effect a cache of the parsing and planning of the query.  Detecting
identicalqueries and caching their results while maintaining good invalidation is a much harder problem. 



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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Does Postgres 14 have a query cache?
Следующее
От: Erik Wienhold
Дата:
Сообщение: Re: can't get psql authentication against Active Directory working