Re: Vacuum I/O throttling

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guy Thornley <guy(at)esphion(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Vacuum I/O throttling
Date: 2003-09-01 13:05:33
Message-ID: 1056.1062421533@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Guy Thornley <guy(at)esphion(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message sad 2003-09-01 14:11:37 session variable
Previous Message Guy Thornley 2003-09-01 04:22:19 Vacuum I/O throttling