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

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Poor query performance on one of two "like" databases in production.
Date: 2010-05-14 18:16:16
Message-ID: AANLkTikpKHQg12xNMrm5_mhNsKV5NS7Yv79tgzaB9Rbo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 14, 2010 at 1:28 PM, <Keaton_Adams(at)mcafee(dot)com> wrote:
> I did run an ANALYZE, then vacuum full, then another ANALYZE on all tables involved in the query.  That didn't change things.  I compared QUERY TUNING settings in both postgresql.conf files and they are identical.  There is a difference in row counts in each table between the databases, but not by much.
>

What's your default_statistics_target value? ie, run "select
default_statistics_target;"

Try setting it to 100 if it is not already, re-run analyze, then try
the queries. The statistics may just be different.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-05-14 18:16:48 Re: Poor query performance on one of two "like" databases in production.
Previous Message Merlin Moncure 2010-05-14 18:07:39 Re: appending items to record variable