Skip to main content

0038 · Retention work follows stored deadlines

Memory namespace · version 38 · source

What it runs​

  • CREATE INDEX observation_scope_expiry_idx ON observation(scope,retention_until,log_offset) WHERE retention_...

SQL​

{schema} is replaced with the validated namespace name when the migration is applied.

8 lines
-- Copyright 2026 The Taisce Authors
-- SPDX-License-Identifier: Apache-2.0

-- The scheduler probes for one due source per project. A sweep then reads a bounded page in
-- deadline order. Neither depends on the project's current policy or scans all retained sources.
CREATE INDEX observation_scope_expiry_idx
ON {schema}.observation(scope,retention_until,log_offset)
WHERE retention_until IS NOT NULL;