On Tue, 2002-10-22 at 17:02, Tom Lane wrote: > [EMAIL PROTECTED] (Jeff Boes) writes: > > We have a few tables that seem to have suffered some kind of > > corruption in their TOAST files. Symptoms include: > > > + Runaway CPU usage during VACUUM ANALYZE (load average > > spikes of 20x normal for 10-15 minutes at a time) and > > more rarely during other operations > > This seems odd. Can you attach to one of the runaway backends with a > debugger and get a stack trace? That might give some clue what the > problem is.
No; we can't do *anything* while this is happening. The load average (on a Linux system) runs up to 30+ within a few minutes. By the time we notice it happening, no command prompts are responsive. -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
