pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 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-11 00:06 Tom Lane <tgl@sss.pgh.pa.us> parent: Lee Wu <Lwu@mxlogic.com> 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