Re: Caching of Queries - Mailing list pgsql-performance

From Gary Doades
Subject Re: Caching of Queries
Date
Msg-id 41527CEB.18344.26EF6F28@localhost
Whole thread Raw
In response to Re: Caching of Queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 22 Sep 2004 at 15:59, Tom Lane wrote:

> Scott Kirkwood <scottakirkwood@gmail.com> writes:
> > What do you think?
>
> I think this would allow the problems of cached plans to bite
> applications that were previously not subject to them :-(.
> An app that wants plan re-use can use PREPARE to identify the
> queries that are going to be re-executed.
>
>             regards, tom lane
>

And then there are the people that would like to upgrade and get a
performance gain without having to change their programs. A simple
conf flag could turn query/plan caching off for all those that rely on each
statement being re-planned.

This is where SQLServer etc. tend to get big wins. I know from direct
comparisons that SQLServer often takes quite a bit longer to parse/plan
a select statement than Postgres, but wins out overall from its
query/plan caching.

Regards,
Gary.


pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: O_DIRECT setting
Next
From: Gaetano Mendola
Date:
Subject: Re: Caching of Queries