index creation in maintenance_work_mem or work_mem

From: "Lee Wu" <Lwu(at)mxlogic(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: index creation in maintenance_work_mem or work_mem
Date: 2005-03-10 19:21:08
Message-ID: ECAB83AA52BCC043A0E24BBC000010241115C3@mxhq-exch.corp.mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

When I read doc, http://www.powerpostgresql.com/PerfList/, I am confused
by:

"maintenance_work_mem: formerly called vacuum_mem, this is the quantity
of RAM PostgreSQL uses for VACUUM, ANALYZE, CREATE INDEX, and adding
foriegn keys."

Is this right? I thought work_mem (or sort_mem prior 8) is used for
CREATE INDEX.

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Nida 2005-03-10 19:36:52 PostgreSQL pam ldap document
Previous Message Alex Turner 2005-03-10 19:18:35 IO Timeout