Re: Does Postgres 14 have a query cache? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Does Postgres 14 have a query cache?
Date
Msg-id 06C7D8B6-A577-411A-8754-63D18C6360B4@thebuild.com
Whole thread Raw
In response to Re: Does Postgres 14 have a query cache?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List 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 by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Does Postgres 14 have a query cache?
Next
From: Erik Wienhold
Date:
Subject: Re: can't get psql authentication against Active Directory working