Units in postgresql.conf - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Units in postgresql.conf
Date
Msg-id 200607201349.37285.peter_e@gmx.net
Whole thread Raw
Responses Re: Units in postgresql.conf  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: Units in postgresql.conf  (Gavin Sherry <swm@linuxworld.com.au>)
Re: Units in postgresql.conf  ("Marko Kreen" <markokr@gmail.com>)
Re: Units in postgresql.conf  (Joe Conway <mail@joeconway.com>)
Re: Units in postgresql.conf  (Josh Berkus <josh@agliodbs.com>)
Re: Units in postgresql.conf  (David Fetter <david@fetter.org>)
Re: Units in postgresql.conf  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Re: Units in postgresql.conf  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
One frequent source of confusion are the different units that the parameters 
in postgresql.conf use.  shared_buffers is in 8 kB, work_mem is in 1 kB; 
bgwriter_delay is in milliseconds, checkpoint_warning is in seconds.  
Obviously, we can't change that without inconveniencing a lot of users.

I think it would be useful to allow units to be added to these settings, for 
example

shared_buffers = 1000kB
checkpoint_warning = 30s

This would also allow

shared_buffers = 512MB

which is a bit cumbersome to calculate right now (you'd need = 65536).

I haven't thought yet how to parse or implement this, but would people find 
this useful?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Katsuhiko Okano
Date:
Subject: Re: poor performance with Context Switch Storm at TPC-W.
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Units in postgresql.conf