Re: Load problems...

I'm afraid you'll have to provide more info than you have... For 7.1.3, what
queries are taking so long? You VACUUM'd your database often (if lots of
updates, inserts and deletes were happening, yes)?

For 7.2b4 - it shouldn't crash, but do you have any clue when it does or
what query/situation might be to blame -- possibly even a backtrace from a
core file you could submit?

Also, this is probably best on -general or -bugs if you have some specific
crash info.

Good luck!

-Mitch

----- Original Message -----
From: "Daniel Andersen" <zedar(at)free2air(dot)com(dot)au>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, December 18, 2001 8:56 PM
Subject: [ADMIN] Load problems...

> Hi,
> Does postgresql have any problems managing load? I'm running a medium
sized
> (30k customers) ISP off a postgresql database but it can't seem to manage
> very well with the dozen or so requests per second it receives. The
machine
> we are handling is plenty powerful enough for a database like this (a dual
> 1ghz p3 machine with 1gb of ram) but for some reason it never runs quite
> perfectly. 7.1.3 would overload the system rapidly and slow to a crawl, so
we
> installed 7.2b4 only to find it runs like a dream (less that 10% cpu usage
> most of the time) but eventually fails to fork and crashes and burns, at
> which point i have to restart it. Could anyone shed any light on a
possible
> solution to these problems?
> Thanks,
> Daniel Andersen
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>