Skip site navigation (1) Skip section navigation (2)

postgres bogged down beyond tolerance

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: postgres bogged down beyond tolerance
Date: 2007-11-14 18:56:50
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062D9A@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Everybody,

The postgres server I have (on redhat linux 2.6 with recent
Dell hardware (4 cpus)) is running terribly slow.

A job it should have gotten done in less than 1 hour
took 7.5 hours last night.

The job I am referencing above gets run via crontab every
evening and I comb the log file fairly diligently.  The
parameters used for the run are indicative as to what orange
I should use to compare to what orange.  The comparison is
not unreasonable is what I am asserting.


I checked kernel parameter
shmmax and it was set as 33554432.  I "fixed" it as
suggested by the manual:
http://www.postgresql.org/docs/8.2/static/kernel-resources.html

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 surprised me.  Since I used -w
flag, I thought it should've written to /etc/sysctl.conf,
but there is no such entry at all and the data of this
file is from 2006.

Can somebody please give me a tip, insight as to what I
am missing, doing wrong?

Here's tail of serverlog file in my data directory:

[2007-11-14 08:53:48.062 PST] <gadb 2007-11-14 08:53:36 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 08:53:59.001 PST] <gadb 2007-11-14 08:53:48 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 08:54:10.782 PST] <gadb 2007-11-14 08:53:59 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 08:54:22.557 PST] <gadb 2007-11-14 08:54:10 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 08:54:34.282 PST] <gadb 2007-11-14 08:54:22 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 09:13:36.444 PST] <gadb 2007-11-14 09:13:24 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 09:13:43.637 PST] <gadb 2007-11-14 09:13:32 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 09:17:16.242 PST] <gadb 2007-11-14 09:17:03 PST idle in transaction>LOG:  unexpected EOF on client connection
[2007-11-14 09:39:22.841 PST] <gjoslyn 2007-11-14 09:39:22 PST SELECT>ERROR:  relation "msysconf" does not exist
[2007-11-14 09:39:22.842 PST] <gjoslyn 2007-11-14 09:39:22 PST SELECT>STATEMENT:  SELECT Config, nValue FROM MSysConf

Many thanks in advance.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu


Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-11-14 19:08:14
Subject: Re: postgres bogged down beyond tolerance
Previous:From: C├ędric VillemainDate: 2007-11-14 10:11:59
Subject: Re: Monitoring Tool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group