Re: Query question - Mailing list pgsql-performance

From Neil Conway
Subject Re: Query question
Date
Msg-id 87llqjj5n0.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: Query question  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Query question
Re: Query question
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> The only thing you're adding to the query is a second SORT step, so it
> shouldn't require any more time/memory than the query's first SORT
> did.

Interesting -- I wonder if it would be possible for the optimizer to
detect this and avoid the redundant inner sort ... (/me muses to
himself)

-Neil


pgsql-performance by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Seeking help with a query that takes too long
Next
From: Manfred Koizar
Date:
Subject: Re: Seeking help with a query that takes too long