Re: [ADMIN] Postgres crashes constantly

2000-03-15 Thread Brian Baquiran
Garry Dolley wrote: > > > Hmm, all the crashes you show us below sound like resource exhaustion > > issues. That's a nice way to say your feeding silly SQL to the server, > > and it's _trying_ to do what you ask... How are you driving the server? > > psql? some sort of CGI? We need more info to h

Re: [ADMIN] Postgres crashes constantly

2000-03-15 Thread Garry Dolley
> Hmm, all the crashes you show us below sound like resource exhaustion > issues. That's a nice way to say your feeding silly SQL to the server, > and it's _trying_ to do what you ask... How are you driving the server? > psql? some sort of CGI? We need more info to help you debug what's > happeni

Re: [ADMIN] Postgres crashes constantly

2000-03-09 Thread Ross J. Reedstrom
Hmm, all the crashes you show us below sound like resource exhaustion issues. That's a nice way to say your feeding silly SQL to the server, and it's _trying_ to do what you ask... How are you driving the server? psql? some sort of CGI? We need more info to help you debug what's happening. In par

[ADMIN] Postgres crashes constantly

2000-03-09 Thread Garry Dolley
I need some advice on how to get Postgres to stop crashing. It crashes consistantly under high server load. I don't want to sound bitchy, but that's just what has been happening lately. now i'll give you a spec on the system: Red Hat Linux 5.2 (kernel 2.0.36) 400Mhz Intel machine with 384 RAM L