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