Alright. I have finally worked out why I was being censored. Majordomo
doesn't like subject lines beginning with the word help. It by default
sends your message off to the moderators and doesn't tell you. Now follows
my original mail:
Hi. I thought by now I would be fairly good at
Matthew Wakeling matt...@flymine.org writes:
If I look at the actual results of the outer-most join, the nested loop,
then I can take the number rows=344491124 and divide it by loops=361427 to
get rows=953. Clearly this means that on average each index scan on a3
returned 953 rows.
Right.
On Wed, 10 Jun 2009, Tom Lane wrote:
...the size of the join relation was estimated long before we even
started to think about nestloop-with-inner-indexscan plans.
That makes a lot of sense.
Matthew
--
Richards' Laws of Data Security:
1. Don't buy a computer.
2. If you must buy a computer,