On 04/13/12 12:40 PM, mbo...@prospectiv.com wrote:
Aggregate (cost=1689951.65..1689951.66 rows=1 width=0)
-> Hash Join (cost=644.62..1687656.17 rows=918194 width=0)
Hash Cond: (a.email_a = o.email)
-> Subquery Scan on a (cost=0.00..1654854.18 rows=9149 width=64)
On Fri, Apr 13, 2012 at 8:40 PM, wrote:
> I am doing a large query so I limit the query to 550 but I get 88 rows
> returned. I increase this to 900 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 t
The following bug has been logged on the website:
Bug reference: 6587
Logged by: Mike Boldi
Email address: mbo...@prospectiv.com
PostgreSQL version: 9.0.3
Operating system: Linux/Redhat
Description:
in the manual it says
If a limit count is given, no more than that ma
