Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 15E979FB7A4 for ; Wed, 20 Jun 2007 17:23:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 36731-04 for ; Wed, 20 Jun 2007 17:23:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 81AF09FB2A4 for ; Wed, 20 Jun 2007 17:23:44 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id l5KKNiEK029254 for ; Wed, 20 Jun 2007 16:23:44 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id l5KKNiRE029251 for ; Wed, 20 Jun 2007 16:23:44 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Wed, 20 Jun 2007 16:23:44 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: pgsql-performance@postgresql.org Subject: Re: Volunteer to build a configuration tool In-Reply-To: <1182360437.14407.40.camel@archimedes> Message-ID: References: <1182298719.4482.133.camel@ipso.snappymail.ca> <7621.1182318230@sss.pgh.pa.us> <9001.1182323187@sss.pgh.pa.us> <1182360437.14407.40.camel@archimedes> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/449 X-Sequence-Number: 25482 On Wed, 20 Jun 2007, Mark Lewis wrote: > as much as some of us might want to make use of every piece of data > available to make the planner into a super-brain, there are lots of > other folks who just want plan stability. It's not like it has to be on for everybody. I look forward to the day when I could see this: $ cat postgresql.conf | grep brain # - Super-brain Query Optimizer - sbqo = on # Enables the super-brain sbqo_reconsider_interval = 5s # How often to update plans sbqo_brain_size = friggin_huge # Possible values are wee, not_so_wee, and -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD