Re: Cached Query Plans - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Cached Query Plans
Date
Msg-id 18717.1207955847@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cached Query Plans  (PFC <lists@peufeu.com>)
List pgsql-hackers
PFC <lists@peufeu.com> writes:
>     And it is very easy to recognize a query we've seen before,

It's not so easy as all that.  Consider search_path.  Consider temp
tables.

The real problem here is entirely on the client side:

>     But, using prepared statements with persistent connections is messy,  
> because you never know if the connection is new or not,

If you were to fix *that* then both this problem and others (such as
setting up desired SET-parameter values) would go away.
        regards, tom lane


pgsql-hackers by date:

Previous
From: PFC
Date:
Subject: Re: Cached Query Plans
Next
From: Gregory Stark
Date:
Subject: Re: Cached Query Plans