Postgres Pro
Downloads
Home   >   mailing lists

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

From Vick Khera
Subject Re: Poor query performance on one of two "like" databases in production.
Date
Msg-id AANLkTikpKHQg12xNMrm5_mhNsKV5NS7Yv79tgzaB9Rbo@mail.gmail.com
Whole thread Raw
In response to 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.  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
On Fri, May 14, 2010 at 1:28 PM,  <Keaton_Adams@mcafee.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
inrow 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.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: appending items to record variable
Next
From: Vick Khera
Date:
Subject: Re: Poor query performance on one of two "like" databases in production.