Re: [PERFORM] Query question

2003-11-14 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Interesting -- I wonder if it would be possible for the optimizer to detect this and avoid the redundant inner sort ... (/me muses to himself) I think the ability to generate two sort steps is a feature, not a bug. This has been often requested in

Re: [PERFORM] Query question

2003-11-14 Thread Christopher Kings-Lynne
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) That's