> > 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?
sort_mem = 1024 shared_buffers = 2048 (tried higher, but didnt' seem to improve anything) max_connections = 300 error message just comes out of the blue, the database is chugging along happily and then suddenly[4059] DEBUG: connection startup failed (fork failure): Resource temporarily unavailable [4059] DEBUG: connection startup failed (fork failure): Resource temporarily unavailable [4059] DEBUG: could not launch checkpoint process (fork failure): Resource temporarily unavailable [4059] DEBUG: connection startup failed (fork failure): Resource temporarily unavailable [4059] DEBUG: connection startup failed (fork failure): Resource temporarily unavailable etc etc etc the database is still responsive up till this point, so i'm assuming there are limitations somewhere that i'm not aware of... ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
