Re: [HACKERS] Progress on fast path sorting, btree index creation time

2012-02-07 Thread Jim "Decibel!" Nasby
On 2/6/12 3:19 PM, Bruce Momjian wrote: > While we're waiting for anyone else to weigh in with an opinion on the > right place to draw the line here, do you want to post an updated > patch with the changes previously discussed? Well, I think we have to ask not only how many people are using f

[HACKERS] Regression in IN( field, field, field ) performance

2008-10-21 Thread Jim 'Decibel!' Nasby
WHERE '12814474045' IN (people.home_phone, people.work_phone, people.mobile_phone) Yeah, not exactly a common case, but at least in 8.1 this was turned into a set of ORs. Starting in 8.2 and in current HEAD, the planner turns that into: Filter: ('12814474045'::text = ANY ((ARRAY[hom