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

Re: 7.1 ... wtf?

From: "August Zajonc" <augustz(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.1 ... wtf?
Date: 2001-05-09 20:10:40
Message-ID: 9dc883$1h9g$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I'm assuming you've read the manual carefully.

Please make doubley sure you configured PostrgreSQL and your system
properly. Server runtime enviroment comes to mind.

Check the error logs, its hard to beleive you are getting such blow ups with
absolutly nothing in any of the logs.

Have you turned on the most verbose loging so you can see all the
transactions on your system? Be suprising if you are still getting nothing.

If you think performance is bad as hell, and it's clearly not a
configuration or user issue (ie, pgsql is at fault), consider writing up a
proper bug report. The fact that a good number of folks successfully use
pgsql for larger installations argues I think for a configuration issue, but
it could certainly be a bug somewhere.



"Thomas Heller" <maniax(at)comtron(dot)net> wrote in message
> Hi again,
> sometime ago i had a post on 7.1 performance .. this is still up-to-date
> cause the performance is bad like hell but i have a little bit bigger
> problem now. I have a dual p3-1ghz + 1gig ram. The hardware is new (asus
> dual board + registered ecc sdram) and is quite nice but postgres7.1 seems
> to mess up with it. I have no idea why, but the server kills himself every
> now and then. the load goes up to 50 and then some minutes later its gone
> (doesn't respond to ANY cmds, no ssh, no shell). i always have to reset
> the only thing i found pointing me towards postgres are these error
> when surfing the pages which use the server as backend.
> I get these errors in a random manner:
> The System is in maintenance mode (something like that)
> The System is in recovery state
> The System is shutting down.
> The System is going up.
> Sorry, to many clients already (2 processes running / 64 max connections
> configured)
> Note: I do not restart the postmaster nor does any script. the system is
> started and running .. why does he say "shutting down"?!! also the
> performance seems to be really crap. (the database is currenly 80mb
> THIS server should worry about).
> any help?
> thank,
> thomas

In response to


pgsql-admin by date

Next:From: GrantDate: 2001-05-10 01:57:33
Subject: Cursor keys not working, repost.
Previous:From: John PagakisDate: 2001-05-09 16:16:38
Subject: RE: Adding columns to existing tables

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