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

From Frank Wiles
Subject Re: Converting postgresql.conf parameters to kilobytes
Date
Msg-id 20040602102002.0e7e4917.frank@wiles.org
Whole thread Raw
In response to Re: Converting postgresql.conf parameters to kilobytes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Converting postgresql.conf parameters to kilobytes
List pgsql-hackers
On Wed, 02 Jun 2004 11:05:43 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Shridhar Daithankar <shridhar@frodo.hserus.net> writes:
> >> I remain unalterably opposed to the notion of measuring
> >shared_buffers> in KB, but if you think you can get such a thing in
> >over my objections,
> 
> > Are you OK with MBs? I am fine with anything.
> 
> No, I'm not.  shared_buffers should be measured in buffers (ie,
> pages). Anything else is obscurantism.  Not to mention highly likely
> to confuse people who are used to how it's been set in the past.
 This may be an unreasonable suggestion, but how about allowing both?  I've seen several configuration systems do the
following:
 
 shared_buffers = 10000     ( shared_buffers in pages )  shared_buffers = 100M      ( 100 MBs of shared_buffers )
shared_buffers= 2048K     ( 2MBs of shared_buffers ) 
 
 Using something like this would leave the old functionality in tact, allow users to use what they like, and shouldn't
introducethat much complexity into the code. 
 
---------------------------------  Frank Wiles <frank@wiles.org>
http://frank.wiles.org---------------------------------



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: ACLs versus ALTER OWNER
Next
From: Alvaro Herrera
Date:
Subject: Re: ACLs versus ALTER OWNER