Re: index creation in maintenance_work_mem or work_mem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lee Wu" <Lwu(at)mxlogic(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: index creation in maintenance_work_mem or work_mem
Date: 2005-03-11 00:06:49
Message-ID: 27078.1110499609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Lee Wu" <Lwu(at)mxlogic(dot)com> 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 right ... as of 8.0. Before that I think we did use sort_mem
as the parameter for CREATE INDEX.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-03-11 00:10:29 Re: Functions and transactions
Previous Message Tom Lane 2005-03-11 00:04:29 Re: IO Timeout