pgsql-bugs@postgresql.org writes:
> Running Postgres version 7.01 on Redhat linux 6.2. When joining on
> more than 10 tables not all of the expected results are returned.
> The query can be repeated several times, with different result sets
> when the data itself is static. The most common result is the return
> of only one record. 11 tables seems to be the magic limit. Joins on
> 10 tables works without a hitch. This join was based on a column id
> that exists in all of the tables.
This seems to be a problem in the genetic query optimizer. But to examine
closer we'd really need to get sample data and queries to reproduce this.
For now you can SET geqo TO 'off'; to disable this.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
