| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | daveg <daveg(at)sonic(dot)net> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Luke Lonergan <llonergan(at)greenplum(dot)com>, pgsql-patches(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Automatically setting work_mem |
| Date: | 2006-04-22 20:49:25 |
| Message-ID: | 20060422204925.GA10180@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Sat, Apr 22, 2006 at 01:14:42PM -0700, David Gould wrote:
> To avoid running out of swap and triggering the oom killer we have
> had to reduce work_mem below what we prefer.
Dunno about your work_mem, but you can make sure the OOM killer
doesn't kill you as follows <http://lwn.net/Articles/104185/>.
HTH :)
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gevik Babakhani | 2006-04-22 21:14:17 | Question about the MemoryContext |
| Previous Message | daveg | 2006-04-22 20:14:42 | Re: [HACKERS] Automatically setting work_mem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | daveg | 2006-04-22 21:20:32 | Re: [HACKERS] Automatically setting work_mem |
| Previous Message | daveg | 2006-04-22 20:14:42 | Re: [HACKERS] Automatically setting work_mem |