Re: Re-Reason of Slowness of Query

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: "tv(at)fuzzy(dot)cz" <tv(at)fuzzy(dot)cz>
Cc: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Re-Reason of Slowness of Query
Date: 2011-03-23 14:19:12
Message-ID: 4D8A0160.6090708@peak6.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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... :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)peak6(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2011-03-23 14:41:40 Re: buffercache/bgwriter
Previous Message tv 2011-03-23 14:16:01 Re: Re-Reason of Slowness of Query