X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E6013D1C4D9 for ; Mon, 11 Aug 2003 23:24:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 54928-07 for ; Mon, 11 Aug 2003 20:23:14 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B8AD4D1C47A for ; Mon, 11 Aug 2003 20:24:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7BNMpSa026935; Mon, 11 Aug 2003 19:22:51 -0400 (EDT) To: josh@agliodbs.com Cc: pgsql-performance@postgresql.org Subject: Re: Odd problem with performance in duplicate database In-reply-to: <200308111559.09924.josh@agliodbs.com> References: <200308111559.09924.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Mon, 11 Aug 2003 15:59:09 -0700" Date: Mon, 11 Aug 2003 19:22:51 -0400 Message-ID: <26934.1060644171@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/183 X-Sequence-Number: 3000 Josh Berkus 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