Re: Performance features the 4th

Manfred Spraul <manfred@colorfullife.com>

From: Manfred Spraul <manfred@colorfullife.com>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-11-05T19:53:21Z
Lists: pgsql-hackers
Jan Wieck wrote:

>
> _Vacuum page delay_:
>
> Tom Lane's napping during vacuums with another tuning option. I 
> replaced the usleep() call with a PG_DELAY(msec) macro in miscadmin.h, 
> which does use select(2) instead. That should address the possible 
> portability problems.

What about skipping the delay if there are no outstanding disk 
operations? Then vacuum would get the full disk bandwidth if the system 
is idle.

--
    Manfred