Yes, I triple checked and the schemas, indexes, FKs, triggers all match. -K
On 5/14/10 12:29 PM, "Stephen Frost" <sfr...@snowman.net> wrote: > * keaton_ad...@mcafee.com (keaton_ad...@mcafee.com) 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general