Yes, I triple checked and the schemas, indexes, FKs, triggers all match.
-K
On 5/14/10 12:29 PM, "Stephen Frost" <sfrost(at)snowman(dot)net> wrote:
> * Keaton_Adams(at)McAfee(dot)com (Keaton_Adams(at)McAfee(dot)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