On Wed, Dec 8, 2010 at 8:57 AM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
> In the page first one takes infinite time by PostgreSQL 9.0.1. Next
> one can be executed very quickly because the join order is explicitely
> specified by cross join syntax. This seems to be a limitation of
> PostgreSQL optimizer and I would like it be removed. Comments?
It's not easy to make the optimizer degrade gracefully when confronted
with a very large number of tables, but I agree it would be worthwhile
if we could figure out how to do it.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company