Load problems...
От | Daniel Andersen |
---|---|
Тема | Load problems... |
Дата | |
Msg-id | E16GXfr-0006h4-00@corky.internettv.net.au обсуждение исходный текст |
Ответы |
Re: Load problems...
Re: Load problems... Re: Load problems... |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: