Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query: select * order by XXX desc offset 10 limit 10 - Mailing list pgsql-general

From Alexander Farber
Subject Re: Slow query: select * order by XXX desc offset 10 limit 10
Date
Msg-id CAADeyWj_i4WmrsMAJ8KOup9QLjbRfpSSGEK467PYz1XX_X3iNw@mail.gmail.com
Whole thread Raw
In response to Re: Slow query: select * order by XXX desc offset 10 limit 10  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Slow query: select * order by XXX desc offset 10 limit 10  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
I've also tried opening cursor:

quincy=> open ref for select to_char(qdatetime, 'YYYY-MM-DD') as
QDATETIME,ID,NAME,CATEGORY,APPSVERSION,OSVERSION,DETAILS,DEVINFO from
quincyview where qdatetime <= now() order by QDATETIME desc ;
ERROR:  syntax error at or near "open"
LINE 1: open ref for select to_char(qdatetime, 'YYYY-MM-DD') as QDAT...
        ^

pgsql-general by date:

Previous
From: Rebecca Clarke
Date:
Subject: Re: Transfer 8.3 to 8.4 - FUNCTION gtsq_in(cstring) does not exist
Next
From: Pavel Stehule
Date:
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10