Re: Vacuum I/O throttling - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Vacuum I/O throttling
Date
Msg-id 1056.1062421533@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum I/O throttling  (Guy Thornley <guy@esphion.com>)
Responses Re: Vacuum I/O throttling  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Vacuum I/O throttling  (Guy Thornley <guy@esphion.com>)
List pgsql-bugs
Guy Thornley <guy@esphion.com> writes:
> Below is a patch for the lazy vacuum. It implements a simple I/O throttle so
> boxen arnt killed for hours a day when VACUUM runs.

Wasn't this idea tried and rejected already?  You haven't given us any
information about actual performance.

> The usleep() could be replaced with a select() call with a timeout an no
> fd_set's to aid portability..

usleep is not portable, AFAIR.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Guy Thornley
Date:
Subject: Vacuum I/O throttling
Next
From: sad
Date:
Subject: session variable