On Fri, Oct 16, 2009 at 5:12 PM, miller_2555 <nabble.30.miller_2555@xxxxxxxxxxxxxxx> wrote: > [...snip...] attempted to set the `join_collapse_limit` to '1' [...] That seems like an odd thing to do - why did you do this? What happens if you don't? I have never seen anything like the bizarrely large row estimates that you have here. Any chance you can extract a standalone, reproducible test case? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance