Re: [PERFORM] Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries

On Mon, Nov 28, 2011 at 9:50 AM, Craig Ringer wrote: > On 11/25/2011 06:53 AM, Maxim Boguk wrote: > >> I understand that position. >> However if assumption: " the definition of ORDER BY --- it happens after >> computing the select list, according to the SQL standard" >> is correct, >> then plans

Re: [PERFORM] Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries

On 11/25/2011 06:53 AM, Maxim Boguk wrote: I understand that position. However if assumption: " the definition of ORDER BY --- it happens after computing the select list, according to the SQL standard" is correct, then plans like: postgres=# EXPLAIN ANALYZE SELECT * from test order by _data limi

Re: [PERFORM] Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries

I understand that position. However if assumption: " the definition of ORDER BY --- it happens after computing the select list, according to the SQL standard" is correct, then plans like: postgres=# EXPLAIN ANALYZE SELECT * from test order by _data limit 10 offset 1000;