Re: [PERFORM] Inefficient Query Plans

2005-02-23 Thread Tom Lane
"Luke Chambers" <[EMAIL PROTECTED]> writes: > The following query plans both result from the very same query run on > different servers. They obviously differ drastically, but I don't why > as one db is a slonied copy of the other with identical postgresql.conf > files. There's an order-of-magnitu

[PERFORM] Inefficient Query Plans

2005-02-22 Thread Luke Chambers
The following query plans both result from the very same query run on different servers. They obviously differ drastically, but I don't why as one db is a slonied copy of the other with identical postgresql.conf files. Both databases are vacuum analyzed nightly. Here is the query: