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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Keaton_Adams(at)McAfee(dot)com
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:54:15
Message-ID: 20100514185415.GY21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2010-05-14 18:55:40 Re: Poor query performance on one of two "like" databases in production.
Previous Message Keaton_Adams 2010-05-14 18:41:04 Re: Poor query performance on one of two "like" databases in production.