On Tue, 28 May 2002, Tom Lane wrote:
> Stephen Robert Norris <srn@commsecure.com.au> writes:
> > One big difference, though, is that with the vacuum problem, the CPU
> > used is almost all (99%) system time; loading up the db with lots of
> > queries increases user time mostly, with little system time...
>
> Hmm, that's a curious point; leaves one wondering about possible kernel
> bugs.
If it turns out to be so, this would not be the first problem I've
heard about in the Linux scheduler. (It was notoriously bad for years.)
I'd suggest a good test would be to try this on a BSD machine and
see if the problem exists there, too. That will at least tell you
if it's Postgres or Linux.
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC