On Thursday 20 July 2006 05:04, Jonah H. Harris wrote: > On 7/20/06, Peter Eisentraut <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
