Skip to content

v20.2.0-alpha.1

tagged this 03 Jun 17:34
49671: sql: handle inserts for partial indexes r=mgartner a=mgartner

This commit makes INSERTs only write new entries to partial indexes when
the new row satisfies the predicate expression of the partial index.

In order to do this, the optimizer synthesizes a column for each partial
index defined on the table that evaluates to true if the respective
partial index should be written to. These columns are interpretted by the
execution engine into a set of IndexIDs to not write to.

Release note: None

Co-authored-by: Marcus Gartner <[email protected]>
Assets 2
Loading