Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> > From looking at vacuum.c I gathered
> vacuum_cost_delay
> > must be >0 to enable the feature - correct?
>
> Yeah, that's right --- delay=0 turns it off. Weird.
> Can anyone else
> reproduce the problem?
>

On a hunch, I turned fsync off and the performance
jumped up to around the same performance I was getting
running the cygwin 7.4.x port. The system is a IBM
Netvista (P4 2.0 ghz w/256 megs of ram, IDE drive)
running Windows 2000 SP4.

I've attached a minimal test script that should
reproduce the issue. However, please be aware that
I've yet to reproduce this issue on XP Pro SP 1
(p4-2.8G, 1g ram, IDE drive). I'll try and see if I
can reproduce this on other systems and get back to
the list.

If anyone has access to Windows 2000 SP4 and wants to
run this test script I'd be very interested in hearing
your results.

Regards,

Shelby Cain

__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail