Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group