Re: Units in postgresql.conf

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: Units in postgresql.conf
Date: 2006-07-22 01:13:07
Message-ID: 200607212113.07743.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thursday 20 July 2006 18:16, Ron Mayer wrote:
> Peter Eisentraut wrote:
> > I think it would be useful to allow units to be added to these settings,
> > for example...
> > 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?
>
> Would this extend to things like "random_page_cost" and similar?
>
> If the random_page_cost were specifiable in seconds or ms it might be
> easier to someday write a program to measure such values on particular
> hardware platforms. (though I guess for that to work, the config file
> would also need to add the reference cost (is it a non-random page access)
> as well...)
>

I'd think no, since random page cost doesn't actually map to any real world
value. Unless of course we wanted to add MV for "magic value", but then
people would want to use that for everything ;-D

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2006-07-22 02:13:54 cygwin initdb failure
Previous Message Andrew Dunstan 2006-07-22 01:11:01 Re: [COMMITTERS] pgsql: Ah, I finally realize why Magnus