Daniele Varrazzo <[EMAIL PROTECTED]> writes: > In my problem I had 2 tables: a small one (accounts), a large one (foo). The > way the query is written doesn't allow the stats from the large table to be > used at all, unless the records from the small table are fetched. This is > independent from the stats accuracy.
> What the planner does is to assume an even distribution in the data in the > joined fields. Sir, you don't know what you're talking about. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance