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 0FE65D1B516 for ; Mon, 8 Sep 2003 00:32:54 +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 90178-10 for ; Sun, 7 Sep 2003 21:32:46 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 20780D1B52D for ; Sun, 7 Sep 2003 21:32:43 -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 h880WQAn015708; Sun, 7 Sep 2003 20:32:26 -0400 (EDT) To: Greg Stark Cc: Mary Edie Meredith , pgsql-performance , osdldbt-general Subject: Re: [GENERAL] how to get accurate values in pg_statistic In-reply-to: <87fzj86vdi.fsf@stark.dyndns.tv> References: <1062697270.6854.3475.camel@ibm-e.pdx.osdl.net> <11537.1062717375@sss.pgh.pa.us> <1062783865.6854.4780.camel@ibm-e.pdx.osdl.net> <87fzj86vdi.fsf@stark.dyndns.tv> Comments: In-reply-to Greg Stark message dated "07 Sep 2003 19:18:01 -0400" Date: Sun, 07 Sep 2003 20:32:26 -0400 Message-ID: <15707.1062981146@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=EMAIL_ATTRIBUTION, IN_REP_TO, RCVD_IN_OSIRUSOFT_COM, REFERENCES, REPLY_WITH_QUOTES X-Spam-Level: X-Archive-Number: 200309/117 X-Sequence-Number: 3483 Greg Stark writes: > Perhaps the default of 10 is simply way > too small and should be raised? I've suspected since the default existed that it might be too small ;-). No one's yet done any experiments to try to establish a better default, though. I suppose the first hurdle is to find a representative dataset. regards, tom lane