Incremental feature development and workload capture in database systems

A method of testing a feature on a database, the method comprising:

• determining a workload comprising one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic;
• executing a baseline run of the workload that does not implement the feature;
• executing a target run of the workload while implementing the feature;
• comparing the baseline run and the target run to identify whether there is a performance regression in the target run;
• and
• in response to identifying the performance regression, rerunning the target run to identify whether the performance regression still exists.

A non-transitory computer readable storage media, programmable to execute instructions that, when executed, cause a processor to:

• determine a workload comprising one or more historical client queries to be rerun for testing the feature, wherein the feature comprises procedural logic;
• execute a baseline run of the workload that does not implement the feature;
• execute a target run of the workload while implementing the feature;
• compare the baseline run and the target run to identify whether there is a performance regression in the target run;
• and
• in response to identifying the performance regression, rerun the target run to identify whether the performance regression still exists.