X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2624D1B9AF for ; Mon, 8 Mar 2004 18:47:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 77425-08 for ; Mon, 8 Mar 2004 14:47:03 -0400 (AST) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id 7D9B3D1B8BC for ; Mon, 8 Mar 2004 14:47:01 -0400 (AST) Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id i28IkkE20108; Mon, 8 Mar 2004 10:46:47 -0800 Message-Id: <200403081846.i28IkkE20108@mail.osdl.org> Date: Mon, 8 Mar 2004 10:46:36 -0800 (PST) From: markw@osdl.org Subject: Re: raising the default default_statistics_target To: tgl@sss.pgh.pa.us Cc: neilc@samurai.com, pgsql-hackers@postgresql.org In-Reply-To: <23460.1078702506@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/270 X-Sequence-Number: 50862 On 7 Mar, Tom Lane wrote: > Neil Conway writes: >> Tom Lane wrote: >>> This is something we need to consider, but we'll need more evidence >>> before making a choice. One thing that we have very little data about >>> is how much difference it makes in the quality of planner choices. > >> Right, but is there a practical way to actually get this data? > > I haven't thought of one yet, but perhaps someone will have an idea. If DBT-3 is an appropriate test, we can get those EXPLAIN ANALYZE changes I have working in the STP version and queued up tests varying the default_statistics_target parameter. Mark