Re: Load problems...

On Wed, 19 Dec 2001, Daniel Andersen wrote:

> 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?

We're probably going to want to look for some more information. What does
the log before failure look like? Are there any warning signs there
(messages about running out of file descriptors, etc)? What do you have
the memory settings (shared buffers, sort memory, etc) and max connections
set to?