Re: constraint exclusion analysis caching

Stephen Frost wrote:
> * Gregory Stark (stark@enterprisedb.com) wrote:
>   
>> "Andrew Dunstan" <andrew@dunslane.net> writes:
>>
>>     
>>> Actual execution of the query in question was talking one tenth of that
>>> time.
>>> ...
>>> but in principle it seems silly to keep paying the same penalty over and
>>> over again.
>>>       
>> I would think constraint_exclusion only really makes sense if you're spending
>> a lot more time executing than planning queries. Either that means you're
>> preparing queries once and then executing them many many times or you're
>> planning much slower queries where planning time is insignificant compared to
>> the time to execute them.
>>     
>
> Would it be possible to change the application to use prepared queries?
> Seems like that'd make more sense the changing it to use the child
> tables directly..  Just my 2c.
>
>     
>   

This is actually a technique already used elsewhere in the app, so it 
will fit quite well. Thanks for the suggestion, though.

(BTW, why does your MUA set Mail-Followup-To: (and do it badly, what's 
more) ?)

cheers

andrew