Re: Poor query performance on one of two "like" databases in production.

From: <Keaton_Adams(at)McAfee(dot)com>
To: <sfrost(at)snowman(dot)net>
Cc: <vivek(at)khera(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Poor query performance on one of two "like" databases in production.
Date: 2010-05-14 18:41:04
Message-ID: C812F560.166D6%keaton_adams@mcafee.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2010-05-14 18:54:15 Re: Poor query performance on one of two "like" databases in production.
Previous Message Stephen Frost 2010-05-14 18:29:48 Re: Poor query performance on one of two "like" databases in production.