Re: Does Postgres 14 have a query cache?

2023-02-18 Thread Tatsuo Ishii
> On Sat, Feb 18, 2023 at 7:47 AM Siddharth Jain wrote: > >> I think the answer is no but wanted to confirm here. this is what my best >> friend told me. >> >> [image: image.png] >> > > I find the last paragraph suspect. The rest is basically correct. Yeah. Pgpool-II has query cache but PgBoun

Re: Does Postgres 14 have a query cache?

2023-02-18 Thread Siddharth Jain
Thanks all for the replies. Just wanted to confirm. On Sat, Feb 18, 2023 at 10:45 AM Steven Lembark wrote: > On Sat, 18 Feb 2023 12:43:42 -0600 > Ron wrote: > > > > I think the answer is no but wanted to confirm here. this is what > > > my best friend told me. > > There are caches for prepared

Re: Does Postgres 14 have a query cache?

2023-02-18 Thread Steven Lembark
On Sat, 18 Feb 2023 12:43:42 -0600 Ron wrote: > > I think the answer is no but wanted to confirm here. this is what > > my best friend told me. There are caches for prepared statements, table rows, indexes. What about the caches are you interested in? -- Steven Lembark Workhorse Computing l

Re: Does Postgres 14 have a query cache?

2023-02-18 Thread Christophe Pettus
> On Feb 18, 2023, at 06:59, Peter J. Holzer 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 a

Re: Does Postgres 14 have a query cache?

2023-02-18 Thread Peter J. Holzer
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 sa