Re: Does Postgres 14 have a query cache?

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Does Postgres 14 have a query cache?
Дата
Msg-id 20230218145920.jllp6gzlekbz7fsi@hjp.at
обсуждение исходный текст
Ответ на Does Postgres 14 have a query cache?  (Siddharth Jain <siddhsql@gmail.com>)
Ответы Re: Does Postgres 14 have a query cache?  (Christophe Pettus <xof@thebuild.com>)
Список pgsql-general
On 2023-02-18 06:46:59 -0800, Siddharth Jain wrote:
> I think the answer is no but wanted to confirm here. this is what my best
> friend told me.
>
> image.png

ChatGPT is your best friend?

It is correct. PostgreSQL doesn't have a query cache. 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.

(The other techniques mentioned are of course also used by other
databases.)

        hp


--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Вложения

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Does Postgres 14 have a query cache?
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Does Postgres 14 have a query cache?