On 03/23/2011 09:16 AM, tv@xxxxxxxx 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@xxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer.php for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
