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 20100514182948.GX21875@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.  (<Keaton_Adams@McAfee.com>)
List pgsql-general
Tree view 
* Keaton_Adams@McAfee.com (Keaton_Adams@McAfee.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
anybetter. 

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
Attachment

pgsql-general by date:

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