Re: Units in postgresql.conf

On 7/20/06, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> 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?

I agree, a lot of newbies have issues with the configuration file. I
have a tiny bit of code (about 20 lines I think) that will handle K,
M, and G suffixes for memory. It would be equally easy to add S for
seconds, ....

In my code, if no suffix existed, I'd just revert to the default
behavior. This is probably what we'd want to do in PostgreSQL as
well.

The only issue in PostgreSQL is knowing what the unit conversion and
scaling factor is for each parameter (8K, 1K, milliseconds, etc);
though, this wouldn't be hard to add at all.

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/