dynamobi/dynamobi — Issue #120: [LDB-202] Make auto deallocation a configuration option for LucidDB
Author: dynamobi-build
Created: 2011-12-30 02:14:45+00:00
State: open
Labels: LCS, LDB

[reporter="ngoodman", created="Tue, 27 Oct 2009 23:26:00 -0500 (GMT-05:00)"]
Currently, in order to reclaim pages no longer referenced, ALTER SYSTEM DEALLOCATE OLD must be called.

Add a new system parameter, "autoDeallocate" that is set to true/false.

"False" makes no change to current behavior.

"True" changes the behavior as follows:

Any statement that could cause pages to be orphaned, and thus candidates for deallocation should trigger an automatic "deallocate old" call after their execution.