From: Denis <denis@startsiden.no>
To: pgsql-sql@postgresql.org
Cc: Rajesh Kumar Mallah. <mallah@trade-india.com>
Subject: Re: Further info : Very high load average but no cpu utilization ?
Date: Thu, 23 May 2002 10:18:17 +0200
Message-ID: <200205231018.17962.denis@startsiden.no> (raw)
In-Reply-To: <200205131734.12619.mallah@trade-india.com>
References: <200205111007.47338.mallah@trade-india.com>
<20020513102120.6BB3C1AFD@druid.net>
<200205131734.12619.mallah@trade-india.com>
On Monday 13 May 2002 02:04 pm, you wrote:
> Hi,
>
> I vaguely remember postmaster not responding to
> kill -9 even on Linux,
>
> i can confirm next time when (god forbids) my postmaster
> goes crazy. ;-)
>
> i feel lucky now that my postmaster is up for more that
> (24 hrs)
>
> (no offence intended , there have been instances of my postmaster
> running for as long as 3 months)
>
> regds
> mallah.
I've been reading this thread with interest, may I ask a few additional
questions ?
- What version of postgresql are you running, compiled from tarball source or
RPM version ?
- Is there any good reason to still run this server on a RedHat 6.2 (non
supported platform from RedHat) ?
- How large are your databases, and how much usage do you have ?
- What kinds of API's do you use to interface ?
- Is the application running locally or do you use IP connections remotely ?
Reason I am asking is that I still have never had postgresql go bad like
that.. I can always stop it properly, and to this date have had very few
problems with postgresql itself. I am interested in your problems because I'd
like to be aware of issues I can eventually run into.. (Better care before
than later ? :-)
My own configuration is like this :
- Postgresql 7.1.3 with OpenFTS, both compiled from source tarballs
- Debian Linux 2.2.x platform
- PHP and Perl applications accessing postgresql from remote machines via IP
- Not very large databases (100s of MBs) but very frequent read, and quite
frequent insert / update activity
For the record, server uptime now is equal to the last time I rebooted for a
kernel recompilation, and during that time I have been forced to restart
postgresql only because of hangups on the Application servers (apache w. php
/ perl) ..
Regards
--
Denis Braekhus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: denis@startsiden.no, mallah@trade-india.com
Subject: Re: Further info : Very high load average but no cpu utilization ?
In-Reply-To: <200205231018.17962.denis@startsiden.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox