Re: Converting postgresql.conf parameters to kilobytes - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Converting postgresql.conf parameters to kilobytes
Date
Msg-id 87aczo7xlm.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Converting postgresql.conf parameters to kilobytes  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:

> Tom Lane wrote:
> > So I disagree with the premise.  Measuring these things in KB is not an
> > improvement.
> 
> I agree, although I think changing effective_cache_size to be measured in KB/MB
> is worth doing.

I have to say as a user the parameters that are measured in postgres blocks
are really annoying and confusing. Really really annoying and confusing.

If someone's playing with this I would suggest they should work something like
dd parameters and take a unit. So you could specify effective_cache=500k or
effective_cache=1M or effective_cache=1G or whatever unit you wanted. 

And this should be true for _all_ parameters that measure space. Consistency
makes it much much easier for people to learn a new system.

-- 
greg



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Official Freeze Date for 7.5: July 1st, 2004
Next
From: Alvaro Herrera
Date:
Subject: Nesting level in protocol?