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, do
Matthew Wakeling 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.
> However, if I
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 understa
