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-magnitude

[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: