[AOLSERVER] PostgreSQL near-lockups

2006-01-16 Thread Dave Siktberg
Janine Sisk recently wrote that she restarts her AOLservers every night to help prevent lockups. I'd like to do that, but often when I do a restart I get several postgresql threads that chew up nearly all the cpu cycles for 30 minutes or more and effectively block access to my site. It appears to

Re: [AOLSERVER] PostgreSQL near-lockups

2006-01-16 Thread Janine Sisk
We have found that some sites, when restarted with "svc -t", go into a funky half-shut-down state and stay there. I don't know why, and it seems to be very consistently some sites (all using PG) and not others. For those sites we use "svc -k", in other words send the kill signal instead o

Re: [AOLSERVER] PostgreSQL near-lockups

2006-01-16 Thread Dave Siktberg
Thanks! I do use "svc -t" when restarting, so I will try -k and observe what happens. I'll also now look more carefully at the logs -- I think there are some clues I haven't yet picked up. Dave From: "Janine Sisk" <[EMAIL PROTECTED]> Sent: Monday, January 16, 2006 9:04 PM > We have found that