Re: [AOLSERVER] PostgreSQL near-lockups

2006-01-18 Thread Bas Scheffers
On 18 Jan 2006, at 04:15, Janine Sisk wrote: The thing I don't understand is why this happens to some sites, while others can be restarted with -t all day long and they will never hang. It seems to hint at there being something wrong with the few sites afflicted by this, doesn't it? These s

Re: [AOLSERVER] PostgreSQL near-lockups

2006-01-18 Thread Don Baccus
On Tuesday 17 January 2006 09:05 pm, you wrote: > Am I on the right track with the following? I think so, yes. The #1 question to answer is "are the long-running threads caused by an application query, or something internal to Postgres?" -- Don Baccus Portland, OR http://donb.furfly.net, htt

Re: [AOLSERVER] PostgreSQL near-lockups

2006-01-18 Thread Janine Sisk
On Jan 17, 2006, at 11:40 PM, Bas Scheffers wrote: On 18 Jan 2006, at 04:15, Janine Sisk wrote: The thing I don't understand is why this happens to some sites, while others can be restarted with -t all day long and they will never hang. It seems to hint at there being something wrong with