Cost-based delay for (other) maintenance operations - Mailing list pgsql-hackers

From Christophe Pettus
Subject Cost-based delay for (other) maintenance operations
Date
Msg-id C3452AD2-8B57-472B-AE0D-C1AC40CF39EE@thebuild.com
Whole thread Raw
List pgsql-hackers
We've run into multiple situations recently where clients were effectively unable to run CREATE INDEX or REINDEX
(CONCURRENTLYor otherwise) due to the load that they imposed on the system, mostly in I/O.  I'd like to propose a
cost-baseddelay system for maintenance operations such as these, paralleling the system for (auto)VACUUM.  Before I
pulltogether a code proposal, I wanted to preflight the idea to make sure it has not been considered and rejected
already,or find out if anyone is working on it already. 


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: BitmapHeapScan streaming read user and prelim refactoring
Next
From: James Hunter
Date:
Subject: Re: AIO v2.3