Re: [HACKERS] [PERFORM] Slow count(*) again...

2011-02-09 Thread Gorshkov
On 2011-02-03 22:48, Scott Marlowe wrote: On Thu, Feb 3, 2011 at 8:40 PM, Greg Smith wrote: Scott Marlowe wrote: Yes they're useful, but like a plastic bad covering a broken car window, they're useful because they cover something that's inherently broken. Awesome. Now we have a car anolog

Re: [PERFORM] Really really slow select count(*)

2011-02-09 Thread felix
On Tue, Feb 8, 2011 at 3:23 PM, Shaun Thomas wrote: > > With 300k rows, count(*) isn't a good test, really. That's just on the edge > of big-enough that it could be > 1-second to fetch from the disk controller, > 1 second you say ? excellent, sign me up 70 seconds is way out of bounds I don'

Re: [PERFORM] Bad query plan when the wrong data type is used

2011-02-09 Thread Vitalii Tymchyshyn
09.02.11 01:14, Dave Crooke написав(ла): You will get the same behaviour from any database product where the query as written requires type coercion - the coercion has to go in the direction of the "wider" type. I have seen the exact same scenario with Oracle, and I view it as a problem with th