Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 03481650436; Sat, 26 Jul 2008 18:49:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91040-05; Sat, 26 Jul 2008 18:48:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 6E66C65042B; Sat, 26 Jul 2008 18:47:08 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m6QLl5la004034; Sat, 26 Jul 2008 17:47:06 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m6QLl5lo004030; Sat, 26 Jul 2008 17:47:05 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Sat, 26 Jul 2008 17:47:05 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Greg Sabino Mullane cc: pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [ADMIN] shared_buffers and shmmax In-Reply-To: <3bd4182ebf79bc4a171f08d03d2edb2f@biglumber.com> Message-ID: References: <3bd4182ebf79bc4a171f08d03d2edb2f@biglumber.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/9 X-Sequence-Number: 4940 On Thu, 24 Jul 2008, Greg Sabino Mullane wrote: > Bite the bullet and start showing the buffer settings as a pure number of bytes > everywhere, and get rid of the confusing '8kB' unit in pg_settings? There's already some changes needed in this area needed to execute the full GUC cleanup/wizard plan that's being worked on. The pg_settings view really should show the value both as the user input it and as it's stored internally for cases like these, which lowers the confusion here a bit even without going so far as converting everything to bytes. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD