Yes, I triple checked and the schemas, indexes, FKs, triggers all match. -K On 5/14/10 12:29 PM, "Stephen Frost" <sfrost@xxxxxxxxxxx> wrote: > * Keaton_Adams@xxxxxxxxxx (Keaton_Adams@xxxxxxxxxx) wrote: >> No luck. I set it in the postgresql.conf file and did a reload, ran analyze >> on the tables and the query plan isn't any better. > > Are you sure the database schemas are identical, including indexes, etc? > There's an index being used on the first query that isn't on the > second.. Perhaps it doesn't/shouldn't exist? Just a thought. > > Stephen -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
