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

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Keaton_Adams(at)mcafee(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Poor query performance on one of two "like" databases in production.
Date: 2010-05-14 18:55:40
Message-ID: AANLkTikr5WD459MT-VfYo4u6Ns5hi5sqKiyc7WvZScLy@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.

Can we see EXPLAIN ANALYZE instead of just EXPLAIN output for the
queries on the two servers?

Also, can you try CLUSTER on the tables involved instead of VACUUM
FULL, to avoid introducing index bloat?

Josh

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keaton_Adams 2010-05-14 19:05:08 Re: Poor query performance on one of two "like" databases in production.
Previous Message Stephen Frost 2010-05-14 18:54:15 Re: Poor query performance on one of two "like" databases in production.