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




---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to