> 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
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
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
> 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
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