Re: [HACKERS] Alpha4 Available Now
On Feb 26, 2010, at 0:55 , Дмитрий Фефелов wrote: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html Performance section: Simplify the forms foo true and foo false to foo = false and foo = true during query optimization. Will it work correct;ly when foo is NULL? It shouldn't have any effect: NULL anything and NULL = anything is NULL I already got it, dumb question ;)) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Alpha4 Available Now
http://developer.postgresql.org/pgdocs/postgres/release-9-0.html Performance section: Simplify the forms foo true and foo false to foo = false and foo = true during query optimization. Will it work correct;ly when foo is NULL? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Avoiding bad prepared-statement plans.
The only case that I think still has any merit is where you get a significantly better plan with known parameter values than without. The projected-cost threshold might be a reasonable approach for attacking that, ie, if estimated cost of generic plan exceeds X then take the time to build a custom plan instead. I'm not sure that really will fix the problem, but it would be a very simple change to make to see how much it helps people. regards, tom lane It will definitely help with partitioned tables. It's very common case when raw data taken from hardware stored in single table first, and later we start to make partitions for each month/week/day. Feature can improve performance transparently to client apps. regards, Dmitry -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers