Re: [SQL] postgres bogged down beyond tolerance

2007-11-17 Thread Gregory Stark
"Tena Sakai" <[EMAIL PROTECTED]> writes: > Namely, I shutdown the database, issued two commands: > /sbin/sysctl -w kernel.shmmax=134217728 > /sbin/sysctl -w kernel.shmall=2097152 > and rebooted the computer. > > After it came up, I checked the shmmax and it is set > as 33554432. Which surpris

Re: [SQL] postgres bogged down beyond tolerance

2007-11-14 Thread Richard Broersma Jr
--- On Wed, 11/14/07, Tena Sakai <[EMAIL PROTECTED]> wrote: > The postgres server I have (on redhat linux with recent > Dell hardware) is running terribly slow. Hello Tena, If you do not get a response to your question regarding performance, you might try resending this email to : [EMAIL PROTECT

[SQL] postgres bogged down beyond tolerance

2007-11-14 Thread Tena Sakai
Hi Everybody, The postgres server I have (on redhat linux with recent Dell hardware) is running terribly slow. A job it should have gotten done in less than 1 hour took 7.5 hours last night. I checked kernel parameter shmmax and it was set as 33554432. I "fixed" it as suggested by the manual: h