Re: Units in postgresql.conf

On Thursday 20 July 2006 05:04, Jonah H. Harris wrote:
> 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.

Yummy, Yummy, I'd say this would be a big boost in ability to tune for a lot
of people.

--
Darcy Buskermolen
Wavefire Technologies Corp.

http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759