Re: [ADMIN] shared_buffers and shmmax

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [ADMIN] shared_buffers and shmmax
Date: 2008-07-26 21:47:05
Message-ID: Pine.GSO.4.64.0807261741330.29072@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-hackers

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rex Mabry 2008-07-28 13:47:18 FATAL: incorrect checksum in control file
Previous Message Carol Walter 2008-07-25 14:30:04 Roles and privileges?

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2008-08-12 10:00:17 TODO build rule
Previous Message Joshua D. Drake 2008-07-24 18:02:39 Re: [DOCS] [ADMIN] shared_buffers and shmmax

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-07-26 23:09:45 Re: Review: DTrace probes (merged version) ver_03
Previous Message Robert Haas 2008-07-26 21:44:11 patch: Add a separate TRUNCATE permission