On 03/23/2011 09:16 AM, tv(at)fuzzy(dot)cz wrote:
> which means this is at least 8.4. Plus the 'distinct' step uses less than
> 1% of total time, so even if you improve it the impact will be minimal.
Haha. Noted. I guess I'm still on my original crusade against DISTINCT.
I was pulling it out of so much old code it's been fused to my DNA.
Actually, we're still on 8.2 so... :)
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
for terms and conditions related to this email
In response to
pgsql-performance by date
|Next:||From: tv||Date: 2011-03-23 14:41:40|
|Subject: Re: buffercache/bgwriter|
|Previous:||From: tv||Date: 2011-03-23 14:16:01|
|Subject: Re: Re-Reason of Slowness of Query|