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:29:48
Message-ID: 20100514182948.GX21875@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:
> 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 Keaton_Adams 2010-05-14 18:41:04 Re: Poor query performance on one of two "like" databases in production.
Previous Message Keaton_Adams 2010-05-14 18:24:31 Re: Poor query performance on one of two "like" databases in production.