Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor query performance on one of two "like" databases in production. - Mailing list pgsql-general

From Stephen Frost
Subject Re: Poor query performance on one of two "like" databases in production.
Date
Msg-id 20100514185415.GY21875@tamriel.snowman.net
Whole thread Raw
In response to Re: Poor query performance on one of two "like" databases in production.  (<Keaton_Adams@McAfee.com>)
Responses Re: Poor query performance on one of two "like" databases in production.
List pgsql-general
Tree view 
* Keaton_Adams@McAfee.com (Keaton_Adams@McAfee.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
Attachment

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Poor query performance on one of two "like" databases in production.
Next
From: Josh Kupershmidt
Date:
Subject: Re: Poor query performance on one of two "like" databases in production.