From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Alex Hunsaker <badalex(at)gmail(dot)com>
Cc:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Magnus Hagander <magnus(at)hagander(dot)net>,
Andrew Dunstan <andrew(at)dunslane(dot)net>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Setting oom_adj on linux?
Date:
2010-01-08 03:26:14
Message-ID:
25346.1262921174@sss.pgh.pa.us (view raw or flat )
Thread:
2010-01-04 15:39:14 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-04 15:45:41 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-04 15:57:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-04 16:03:47 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-04 16:07:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-04 16:10:54 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-04 16:40:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-04 16:41:42 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-04 16:55:15 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-04 16:59:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-04 17:00:28 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-04 16:59:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-07 23:58:16 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 03:26:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 03:46:23 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 12:07:21 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-08 14:27:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 16:01:31 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 16:37:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 16:45:50 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-08 17:12:13 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-01-09 21:06:59 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-01-09 21:53:24 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-09 22:07:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-09 22:04:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-11 18:43:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 17:07:14 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-01-08 17:11:00 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 17:24:39 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-01-08 19:30:44 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 19:45:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 20:22:38 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-08 22:24:06 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-01-08 22:38:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-09 03:46:10 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-09 03:57:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 17:24:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 17:37:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-01-08 17:56:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 17:45:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-08 17:34:29 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-08 17:03:36 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-01-08 14:53:59 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-01-08 15:24:05 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-01-04 16:17:19 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-01-04 16:49:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-04 18:09:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-04 18:32:36 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-01-04 21:34:45 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Lists:
pgsql-hackers
Alex Hunsaker <badalex(at)gmail(dot)com> writes:
> FWIW here is the patch I run. Stupid as the patch may be, count it as
> a +1 for people in the field doing this. Hence a reason to think
> about doing something in core. maybe.
Thanks for the patch --- it's certainly a fine starting point.
We can either drop this in core (with a lot of #ifdef LINUX added)
or expect Linux packagers to carry it as a patch. Given that the
packagers would also have to modify their init scripts to go with,
the patch route is not unreasonable. Comments?
> This has some oddities like it does not reset oom to 0 for the (wal)
> writer process.
FWIW, I think that's probably a feature --- I'd vote for only resetting
in regular backends and possibly autovac workers.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-01-08 03:38:30Subject : Re: damage control modePrevious :From : Tom LaneDate : 2010-01-08 03:20:37Subject : Re: damage control mode
