Re: Question about postgresql.conf memory settings

The Documentation is correct. In your case it means 32768 KB. Please
read the postgres documentation for more info.

From Postgres Documentation :
"maintenance_work_mem (integer): Specifies the maximum amount of memory
to be used in maintenance operations, such as VACUUM,
CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. The value is specified in
kilobytes, and
defaults to 16384 kilobytes (16 MB). Since only one of these operations
can be executed at a time
by a database session, and an installation normally doesn't have very
many of them happening concurrently,
it's safe to set this value significantly larger than work_mem. Larger
settings may improve
performance for vacuuming and for restoring database dumps."

-Chandu

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tony Caduto
Sent: Wednesday, April 26, 2006 9:45 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Question about postgresql.conf memory settings

Hi,
I am a little confused on some of the memory setting in the
postgresql.conf

for example:

maintenance_work_mem = 32768    # min 1024, size in KB

is the 32768 bytes or KB

The comment says size is in KB, so I would assume this is actually 32768
* 1024

or is it really 32k?

If it is 32k shouldn't the comment say size in bytes not KB?

--
Tony


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq