Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query using LIMIT [SOLVED] - Mailing list pgsql-general

From Poul Møller Hansen
Subject Re: Slow query using LIMIT [SOLVED]
Date
Msg-id 4339542E.1020605@pbnet.dk
Whole thread Raw
In response to Slow query using LIMIT  (Poul Møller Hansen <freebsd@pbnet.dk>)
List pgsql-general
Tree view 
> Doing the following query:
> explain analyze SELECT * FROM my.tablename WHERE node = '1234567890'
> AND date BETWEEN '2005-03-27' AND NOW() ORDER BY id DESC

ORDER BY node,id is forcing the planner to use the right index.

Thanks,
 Poul

pgsql-general by date:

Previous
From: boinger
Date:
Subject: Re: Performance woes relating to DISTINCT (I think)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Extraordinarily slow!!