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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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