Re: 7.0.2 issues / Geocrawler - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.0.2 issues / Geocrawler
Date
Msg-id 24331.963426066@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.0.2 issues / Geocrawler  (Tim Perdue <tperdue@valinux.com>)
List pgsql-hackers
Tim Perdue <tperdue@valinux.com> writes:
> The Hermit Hacker wrote:
>> just curious, but what if you remove the ORDER BY, just to test ... is it
>> that much faster without then with?  Just want to narrow down *if* its a
>> sorting issue or not, that's all ...

> Good call - it was instantaneous as it used to be.

How much data is getting passed through the sort step --- you might need
to raise the query LIMIT to find out...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tim Perdue
Date:
Subject: Re: Serious Performance Loss in 7.0.2??
Next
From: Tom Lane
Date:
Subject: Re: Serious Performance Loss in 7.0.2??