Re: [BUGS] Possible bug in PostgreSQL query planner

2002-10-07 Thread Tom Lane
Matthew Wakeling <[EMAIL PROTECTED]> writes: > I have encountered what seems to be a bad decision made by the query > planner, on a quite simple query. I have attached a shell script which > creates a large (180MB) sql script, to demonstrate the problem. These queries are forcing the join order;

[BUGS] Possible bug in PostgreSQL query planner

2002-10-07 Thread Matthew Wakeling
I have encountered what seems to be a bad decision made by the query planner, on a quite simple query. I have attached a shell script which creates a large (180MB) sql script, to demonstrate the problem. To reproduce, execute the bash script, and pipe the stdout into psql. Redirect the stdout of