Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd problem with performance in duplicate database - Mailing list pgsql-performance

From Tom Lane
Subject Re: Odd problem with performance in duplicate database
Date
Msg-id 26934.1060644171@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd problem with performance in duplicate database  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Odd problem with performance in duplicate database  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> By everything I can measure, the live database and the test are
> identical; yet the test does not think that idx_caseclients_case is
> very accessable, and the live database knows it is.

Let's see the pg_stats rows for case_clients in both databases.  The
entries for trial_groups might be relevant too.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Odd problem with performance in duplicate database
Next
From: Tom Lane
Date:
Subject: Re: Odd problem with performance in duplicate database