X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E3A253797 for ; Sat, 7 May 2005 15:01:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60961-09 for ; Sat, 7 May 2005 18:01:11 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id E2AC4537F2 for ; Sat, 7 May 2005 13:16:40 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr4.postgresql.org (Postfix) with ESMTP id DFBB85B06C4 for ; Sat, 7 May 2005 15:50:48 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j47FexaH002902; Sat, 7 May 2005 11:40:59 -0400 (EDT) To: Jona Cc: Christopher Kings-Lynne , pgsql-performance@postgresql.org Subject: Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 In-reply-to: <427CADD3.6050106@oismail.com> References: <4279ECC1.4050000@oismail.com> <24106.1115308954@sss.pgh.pa.us> <427B1E0A.3000108@oismail.com> <427B2D9E.2030804@familyhealth.com.au> <427B51AB.4060501@oismail.com> <13858.1115387983@sss.pgh.pa.us> <427CADD3.6050106@oismail.com> Comments: In-reply-to Jona message dated "Sat, 07 May 2005 14:00:19 +0200" Date: Sat, 07 May 2005 11:40:59 -0400 Message-ID: <2901.1115480459@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/71 X-Sequence-Number: 12235 Jona writes: > anyway, here's the info for relpages: > Live Server: 424 > Test Server: 338 I was asking about the indexes associated with the table, not the table itself. regards, tom lane