Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4224: issue with LIMIT and ORDER BY
On Thu, Jun 05, 2008 at 06:15:29PM +, Lawrence Cohan wrote:
> Following queries run FOREVER in PG if an index exists on the "id"
column
> which is a integer - serial and PKey on the table
On Thu, Jun 05, 2008 at 06:15:29PM +, Lawrence Cohan wrote:
> Following queries run FOREVER in PG if an index exists on the "id" column
> which is a integer - serial and PKey on the table.
> SELECT id FROM orders WHERE merchant_id = xx ORDER BY id DESC LIMIT 31
> -- or 30, 29, 28, 27, 26,
The following bug has been logged online:
Bug reference: 4224
Logged by: Lawrence Cohan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: red hat 4.1.1-52
Description:issue with LIMIT and ORDER BY
Details:
Following queries run FOREVER in
