Quick Links

Re: Slow query: select * order by XXX desc offset 10 limit 10

From:	Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Slow query: select * order by XXX desc offset 10 limit 10
Date:	2011-10-14 09:27:33
Message-ID:	CAADeyWj_i4WmrsMAJ8KOup9QLjbRfpSSGEK467PYz1XX_X3iNw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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...
^

In response to

Re: Slow query: select * order by XXX desc offset 10 limit 10 at 2011-10-14 09:14:27 from Alexander Farber

Responses

Re: Slow query: select * order by XXX desc offset 10 limit 10 at 2011-10-14 09:30:37 from Pavel Stehule

Browse pgsql-general by date

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