On 22 Sep 2004 at 15:59, Tom Lane wrote:

> Scott Kirkwood <[EMAIL PROTECTED]> 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.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to