On 28.11.2011 17:42, Joost Kraaijeveld wrote: > - Why does explain say it takes "7876150720 rows"? Any idea where this number came from? No matter what I do, the nested loop row estimates are alway very close to the product of the two estimates (outer rows * inner rows). Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance