Re: [ADMIN] index creation in maintenance_work_mem or work_mem

"Lee Wu" <[EMAIL PROTECTED]> writes: > "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. Yes it is ri

[ADMIN] index creation in maintenance_work_mem or work_mem

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_me