Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Greg Spiegelberg
2010/5/7 Silvio Brandani > 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 because I have s

Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Silvio Brandani
Giles Lean ha scritto: Silvio Brandani 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 misfeature of Linux. At le

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:

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 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 invo

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 ker

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 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 oom-killer: gfp_mask=0

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 pgblade0

Re: [ADMIN] postgres invoked oom-killer

2010-05-07 Thread Greg Spiegelberg
On Fri, May 7, 2010 at 8:26 AM, 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 > *** snip *** > May 6 22:31:30 pgblade02

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