Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: constraint ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 13 Topic 9331 of 10965
Post > Topic >>

Re: constraint exclusion analysis caching

by stark@[EMAIL PROTECTED] (Gregory Stark) May 9, 2008 at 03:14 PM

"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.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!

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




 13 Posts in Topic:
constraint exclusion analysis caching
andrew@[EMAIL PROTECTED]   2008-05-09 08:47:26 
Re: constraint exclusion analysis caching
nagy@[EMAIL PROTECTED] (  2008-05-09 15:05:09 
Re: constraint exclusion analysis caching
tgl@[EMAIL PROTECTED] (T  2008-05-09 10:01:44 
Re: constraint exclusion analysis caching
stark@[EMAIL PROTECTED]   2008-05-09 15:14:42 
Re: constraint exclusion analysis caching
sfrost@[EMAIL PROTECTED]   2008-05-09 15:19:35 
Re: constraint exclusion analysis caching
andrew@[EMAIL PROTECTED]   2008-05-09 16:25:34 
Re: constraint exclusion analysis caching
sfrost@[EMAIL PROTECTED]   2008-05-09 16:46:03 
Re: constraint exclusion analysis caching
andrew@[EMAIL PROTECTED]   2008-05-10 12:22:54 
Re: constraint exclusion analysis caching
sfrost@[EMAIL PROTECTED]   2008-05-12 10:06:29 
Re: constraint exclusion analysis caching
andrew@[EMAIL PROTECTED]   2008-05-12 10:28:43 
Re: constraint exclusion analysis caching
alvherre@[EMAIL PROTECTED  2008-05-12 10:47:12 
Re: constraint exclusion analysis caching
simon@[EMAIL PROTECTED]   2008-05-09 15:30:47 
Re: constraint exclusion analysis caching
stark@[EMAIL PROTECTED]   2008-05-10 11:00:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 9:20:22 CST 2008.