Tim Perdue <tperdue(at)valinux(dot)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