Re: Odd problem with performance in duplicate database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Odd problem with performance in duplicate database
Date: 2003-08-11 23:22:51
Message-ID: 26934.1060644171@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-08-11 23:46:21 Re: Odd problem with performance in duplicate database
Previous Message Bruce Momjian 2003-08-11 22:59:30 Re: Perfomance Tuning