Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> I'm putting 8.0 through its paces and here are a few
> things I've noticed on the native win32 port running
> on my workstation (2.0g p4 w/256 megs of ram).
> Here is the output of "vacuum verbose item":
> DETAIL: CPU -1.-1612s/-1.99u sec elapsed 1434.79 sec.
> CPU 1081264882.-821s/0.02u sec elapsed 1682.87 sec.
Hmm ... something broken about getrusage() on Windows?
CC'd to pgsql-hackers-win32 for comment.
> My other concern is the length of time that vacuum
> runs when cost based vacuuming is disabled.
Are you sure you had cost-based vac disabled? I tried to reproduce
your experiment here. I saw some degradation in vacuuming speed
but not nearly as large as you're reporting (85 vs 73 seconds),
and as far as I could tell it was still maxing out my disk.
But the behavior you're describing is exactly what I'd expect if
cost-based vac was on.
regards, tom lane
In response to
pgsql-hackers-win32 by date
|Next:||From: Mario Ivankovits||Date: 2004-08-19 17:50:32|
|Subject: InitDB Failure on install|
|Previous:||From: Fabien COELHO||Date: 2004-08-19 16:46:38|
|Subject: tablespace and pg_dump/restore|
pgsql-general by date
|Next:||From: Joe Conway||Date: 2004-08-19 17:10:29|
|Subject: Re: [HACKERS] SRPM for 8.0.0 beta?|
|Previous:||From: Mark Gibson||Date: 2004-08-19 16:38:18|
|Subject: Forwarding kerberos credentials|