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 19:05:08
Message-ID: C812FB04.166DF%keaton_adams@mcafee.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, PG settings are the same. Just checked again.

-K

On 5/14/10 12:54 PM, "Stephen Frost" <sfrost(at)snowman(dot)net> wrote:

> * Keaton_Adams(at)McAfee(dot)com (Keaton_Adams(at)McAfee(dot)com) wrote:
>> Yes, I triple checked and the schemas, indexes, FKs, triggers all match.
>
> Have you checked over for any enable_* settings that are off? Identical
> work_mem and maintenance_work_mem settings?
>
> Thanks,
>
> Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2010-05-14 19:10:17 Re: List traffic
Previous Message Josh Kupershmidt 2010-05-14 18:55:40 Re: Poor query performance on one of two "like" databases in production.