Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Sat, 26 Jul 2008 17:47:05 -0400 (EDT)
  • Message-id: <Pine.GSO.4.64.0807261741330.29072@westnet.com> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group