Re: constraint exclusion analysis caching

Stephen Frost wrote:
> * Gregory Stark (stark@[EMAIL PROTECTED]
) wrote:
>   
>> "Andrew Dunstan" <andrew@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers