Skip site navigation (1) Skip section navigation (2)

Re: integer values in conf file

From: Lew <noone(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: integer values in conf file
Date: 2008-08-31 16:17:42
Message-ID: K_SdnaUWcKq7WSfVnZ2dnUVZ_oqdnZ2d@comcast.com (view raw or flat)
Thread:
Lists: pgsql-general
Thomas Finneid wrote:
> Hi
> 
> A quick question, In the doc on the net for miscellaneous config 
> options, e.g. maintenance_work_mem, the doc states the argument is an 
> integer, but it does not state whether the number should be in Bytes, 
> KB, MB. From examples I have seen, I conclude its in KB, but is that 
> correct?

 From <http://www.postgresql.org/docs/8.3/static/config-setting.html>:
> Some settings specify a memory or time value. 
> Each of these has an implicit unit, which is either kilobytes, blocks 
> (typically eight kilobytes), milliseconds, seconds, or minutes. 
> Default units can be queried by referencing pg_settings.unit. 
> For convenience, a different unit can also be specified explicitly. 
> Valid memory units are kB (kilobytes), MB (megabytes), and GB (gigabytes); 
> valid time units are ms (milliseconds), s (seconds), min (minutes), 
> h (hours), and d (days). Note that the multiplier for memory units is 
> 1024, not 1000. 

-- 
Lew

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2008-08-31 17:19:49
Subject: Re: integer values in conf file
Previous:From: LewDate: 2008-08-31 16:14:45
Subject: Re: DUPS in tables columns ERROR: column ". . . " does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group