Angva wrote: > Guess I'm about ready to wrap up this thread, but I was just wondering > if Alvaro might have confused work_mem with maintenance_work_mem. The > docs say that work_mem is used for internal sort operations, but they > also say maintenance_work_mem is used for create index. My tests seem > to show that clustering does not use work_mem at all (or my clusters > don't use very much of it for whatever reason). Can anyone confirm > this?
Huh, sure, "system" operations like cluster, create index or vacuum use maintenance_work_mem, not work_mem (the latter being used mainly by regular queries, i.e. select, update, delete). I just hadn't read the whole background of your problem so I didn't notice you were talking about cluster. Sorry about being sloppy on that. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
