Re: [GENERAL] Kernel kills postgres process - help need

2008-02-10 Thread Alvaro Herrera
Hervé Piedvache escribió: > Another, may be stupid question, but when you have several web nodes like > me ... with several physical database (I'm not talking about replication, > it's just that the web node can contact 3 or 4 differents database for > differents applications), what is the best

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-07 Thread Hervé Piedvache
Thanks Alvaro for your answer really clear. Another, may be stupid question, but when you have several web nodes like me ... with several physical database (I'm not talking about replication, it's just that the web node can contact 3 or 4 differents database for differents applications), what i

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-07 Thread Gregory Stark
"Alvaro Herrera" <[EMAIL PROTECTED]> writes: > The PHP model of persistent connections is silly and useless, because each > PHP process keeps an open connection (or more than one, if it connects to > different databases), which is then idle most of the time. Some might say that keeping PHP proces

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-07 Thread Alvaro Herrera
Hervé Piedvache escribió: > Tom, > > Le mercredi 9 janvier 2008, Tom Lane a écrit : > > =?utf-8?q?Herv=C3=A9_Piedvache?= <[EMAIL PROTECTED]> writes: > > > When I have a lot of connexions (persistante connexions from 6 web > > > apache/php serveurs using PDO, about 110 process on each web servers)

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-07 Thread Hervé Piedvache
Tom, Le mercredi 9 janvier 2008, Tom Lane a écrit : > =?utf-8?q?Herv=C3=A9_Piedvache?= <[EMAIL PROTECTED]> writes: > > When I have a lot of connexions (persistante connexions from 6 web > > apache/php serveurs using PDO, about 110 process on each web servers) on > > the server, or long request, it

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-10 Thread Martijn van Oosterhout
On Wed, Jan 09, 2008 at 04:59:45PM -0600, Scott Marlowe wrote: > On Jan 9, 2008 3:57 PM, Hervé Piedvache <[EMAIL PROTECTED]> wrote: > > Jan 9 20:30:48 db2 kernel: Free swap = 15623168kB > > Jan 9 20:30:48 db2 kernel: Total swap = 15623172kB > > Jan 9 20:30:48 db2 kernel: Free swap: 156231

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Robert Treat
On Wednesday 09 January 2008 18:21, Joshua D. Drake wrote: > On Wed, 09 Jan 2008 14:17:14 -0800 > > Jeff Davis <[EMAIL PROTECTED]> wrote: > > I posted to LKML here: > > > > http://kerneltrap.org/mailarchive/linux-kernel/2007/2/12/54202 > > > > because linux has a behavior -- which in my opinion is

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 09 Jan 2008 14:17:14 -0800 Jeff Davis <[EMAIL PROTECTED]> wrote: > I posted to LKML here: > > http://kerneltrap.org/mailarchive/linux-kernel/2007/2/12/54202 > > because linux has a behavior -- which in my opinion is a bug -- that > causes t

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Scott Marlowe
On Jan 9, 2008 3:57 PM, Hervé Piedvache <[EMAIL PROTECTED]> wrote: SNIP > 0+0 > Jan 9 20:30:48 db2 kernel: Free swap = 15623168kB > Jan 9 20:30:48 db2 kernel: Total swap = 15623172kB > Jan 9 20:30:48 db2 kernel: Free swap: 15623168kB > Jan 9 20:30:48 db2 kernel: oom-killer: gfp_mask=0x

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Hervé Piedvache
Le mercredi 09 janvier 2008, Jeff Davis a écrit : > On Wed, 2008-01-09 at 22:57 +0100, Hervé Piedvache wrote: > > Hi, > > > > I have a big trouble with a PostgreSQL server ... regulary since I have > > added 8 Gb of memory, on a server having already 8Gb of memory, I have > > troubles. Nothing el

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Hervé Piedvache
Tom, Le mercredi 09 janvier 2008, Tom Lane a écrit : > =?utf-8?q?Herv=C3=A9_Piedvache?= <[EMAIL PROTECTED]> writes: > > When I have a lot of connexions (persistante connexions from 6 web > > apache/php serveurs using PDO, about 110 process on each web servers) on > > the server, or long request, i

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Tom Lane
=?utf-8?q?Herv=C3=A9_Piedvache?= <[EMAIL PROTECTED]> writes: > When I have a lot of connexions (persistante connexions from 6 web apache/php > serveurs using PDO, about 110 process on each web servers) on the server, or > long request, it's difficult for me to know when it's appening, the kernel

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Jeff Davis
On Wed, 2008-01-09 at 22:57 +0100, Hervé Piedvache wrote: > Hi, > > I have a big trouble with a PostgreSQL server ... regulary since I have added > 8 Gb of memory, on a server having already 8Gb of memory, I have troubles. > Nothing else have changed ... I'm on a Dell server, and all the memory