Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Silvio Brandani
Giles Lean ha scritto: Silvio Brandani silvio.brand...@tech.sdb.it wrote: yes the server is dedicated to PostgreSQL. Could be a bug of PostgreSQL the fact that the system went Out of Memory?? Wath can be the cause of it? Regards, Silvio The out of memory killer is a totally bogus

Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Greg Spiegelberg
2010/5/7 Silvio Brandani silvio.brand...@tech.sdb.it Greg Spiegelberg ha scritto: Is this system a virtual machine? Greg No is not, is up and runnig from 4 months , 60 G of data in 9 different databases. Lately we import a new schema in one of those databases . Okay. I asked

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Lacey Powers
Silvio Brandani wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 May 6 22:31:01 pgblade02 kernel: May 6 22:31:01 pgblade02 kernel: Call Trace: May

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Greg Spiegelberg
On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani silvio.brand...@tech.sdb.it wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 *** snip *** May

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Silvio Brandani
Lacey Powers ha scritto: Silvio Brandani wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 May 6 22:31:01 pgblade02 kernel: May 6 22:31:01

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Silvio Brandani
Greg Spiegelberg ha scritto: On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani silvio.brand...@tech.sdb.it mailto:silvio.brand...@tech.sdb.it wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Silvio Brandani
Silvio Brandani ha scritto: Lacey Powers ha scritto: Silvio Brandani wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 May 6 22:31:01 pgblade02

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Silvio Brandani
Silvio Brandani ha scritto: Greg Spiegelberg ha scritto: On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani silvio.brand...@tech.sdb.it mailto:silvio.brand...@tech.sdb.it wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Lacey Powers
Silvio Brandani wrote: Lacey Powers ha scritto: Silvio Brandani wrote: We have a postgres 8.3.8 on linux We get following messages int /var/log/messages: May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 May 6 22:31:01 pgblade02 kernel: