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