Re: Does Postgres 14 have a query cache?

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Does Postgres 14 have a query cache?
Date: 2023-02-18 14:59:20
Message-ID: 20230218145920.jllp6gzlekbz7fsi@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2023-02-18 16:08:14 Re: Does Postgres 14 have a query cache?
Previous Message David G. Johnston 2023-02-18 14:54:36 Re: Does Postgres 14 have a query cache?