Skip site navigation (1) Skip section navigation (2)

Re: BUG #6587: Limit on a query is mis-documented

From: Greg Stark <stark(at)mit(dot)edu>
To: mboldi(at)prospectiv(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6587: Limit on a query is mis-documented
Date: 2012-04-14 01:34:16
Message-ID: CAM-w4HOjqczwhw7kJ1yhO1XbkXYDTunNq1uj==dGZV=OdCgjzA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, Apr 13, 2012 at 8:40 PM,  <mboldi(at)prospectiv(dot)com> wrote:
> I am doing a large query so I limit the query to 5500000 but I get 88 rows
> returned. I increase this to 9000000 and get 136 rows returned ..
> explain Plan ...

Please send the query with and without the LIMIT.

It might also help to send more such as the schema and possibly even
the data if that's possible. But at least send the queries so we can
see what you're doing. The plan does not look correct for what you've
described.

-- 
greg

In response to

pgsql-bugs by date

Next:From: John R PierceDate: 2012-04-14 01:53:26
Subject: Re: BUG #6587: Limit on a query is mis-documented
Previous:From: Robert HaasDate: 2012-04-13 22:53:48
Subject: Re: BUG #6572: The example of SPI_execute is bogus

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group