pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
index creation in maintenance_work_mem or work_mem
2+ messages / 2 participants
[nested] [flat]

* index creation in maintenance_work_mem or work_mem
@ 2005-03-10 19:21 Lee Wu <Lwu@mxlogic.com>
  2005-03-11 00:06 ` Re: index creation in maintenance_work_mem or work_mem Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Lee Wu @ 2005-03-10 19:21 UTC (permalink / raw)
  To: 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: index creation in maintenance_work_mem or work_mem
  2005-03-10 19:21 index creation in maintenance_work_mem or work_mem Lee Wu <Lwu@mxlogic.com>
@ 2005-03-11 00:06 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-03-11 00:06 UTC (permalink / raw)
  To: Lee Wu <Lwu@mxlogic.com>; +Cc: pgsql-admin

"Lee Wu" <Lwu@mxlogic.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-11 00:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-10 19:21 index creation in maintenance_work_mem or work_mem Lee Wu <Lwu@mxlogic.com>
2005-03-11 00:06 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox