Re: Re-Reason of Slowness of Query
От
Shaun Thomas
Тема
Re: Re-Reason of Slowness of Query
Дата
Msg-id
4D8A0160.6090708@peak6.com
Ответ на
Re: Re-Reason of Slowness of Query (tv@fuzzy.cz)
Список
Дерево обсуждения
Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Re-Reason of Slowness of Query Chetan Suttraway <chetan.suttraway@enterprisedb.com>
Re: Re-Reason of Slowness of Query tv@fuzzy.cz
Re: Re-Reason of Slowness of Query Chetan Suttraway <chetan.suttraway@enterprisedb.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query Chetan Suttraway <chetan.suttraway@enterprisedb.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Re-Reason of Slowness of Query tv@fuzzy.cz
Re: Re-Reason of Slowness of Query Shaun Thomas <sthomas@peak6.com>
Re: Re-Reason of Slowness of Query tv@fuzzy.cz
Re: Re-Reason of Slowness of Query Shaun Thomas <sthomas@peak6.com>
Re: Re-Reason of Slowness of Query Adarsh Sharma <adarsh.sharma@orkash.com>
On 03/23/2011 09:16 AM, tv@fuzzy.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@peak6.com ______________________________________________ See http://www.peak6.com/email_disclaimer.php for terms and conditions related to this email
В списке pgsql-performance по дате отправления