Contents
plans/ — Document Index
Quick-reference inventory of all planning documents. Updated manually — add new entries when creating documents.
Type key: PLAN = implementation plan · GAP = gap analysis · REPORT = research/assessment · ADR = architecture decision · STATUS = progress tracking
plans/ (root)
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN.md | PLAN | — | Master implementation plan (Phases 0–12) |
| PLAN_EDGE_CASES.md | PLAN | Proposed | Edge case catalogue with workarounds & prioritised remediation |
| PLAN_EDGE_CASES_TIVM_IMPL_ORDER.md | PLAN | Proposed | Combined implementation order for PLAN_EDGE_CASES + PLAN_TRANSACTIONAL_IVM_PART_2 |
| PLAN_FEATURE_CLEANUP.md | PLAN | In progress | Remove low-value surface before public release |
adrs/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_ADRS.md | PLAN | Proposed | ADR collection — all architecture decisions in one document |
dbt/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_DBT_ADAPTER.md | PLAN | Proposed | dbt integration via full custom adapter |
| PLAN_DBT_MACRO.md | PLAN | Implemented | dbt integration via custom materialization macro |
ecosystem/
| File | Type | Status | Summary |
|---|---|---|---|
| GAP_ANALYSIS_EPSIO.md | GAP | — | Core SQL IVM engine comparison vs Epsio |
| GAP_ANALYSIS_FELDERA.md | GAP | — | Core SQL IVM engine comparison vs Feldera |
| PLAN_CLOUDNATIVEPG.md | PLAN | Implemented | CloudNativePG image volume extension |
| PLAN_ECO_SYSTEM.md | PLAN | Proposed | Supportive projects ecosystem plan |
| REPORT_READYSET.md | REPORT | Reference | pg_trickle vs ReadySet comparison & layered deployment guidance |
| REPORT_TIMESCALEDB.md | REPORT | Research | TimescaleDB synergy — IVM over hypertables & design lessons |
| GAP_PG_IVM_COMPARISON.md | GAP | Reference | pg_trickle vs pg_ivm comparison & gap analysis |
infra/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_CITUS.md | PLAN | — | Citus distributed table compatibility |
| PLAN_CODECOV.md | PLAN | Implementing | Codecov integration for coverage reporting |
| PLAN_GITHUB_ACTIONS_COST.md | PLAN | — | Reduce GitHub Actions resource consumption |
| PLAN_DOCKER_IMAGE.md | PLAN | Draft | Official Docker image |
| REPORT_EXTERNAL_PROCESS.md | REPORT | Exploration | External sidecar process feasibility study |
| PLAN_MULTI_DATABASE.md | PLAN | Draft | Multi-database support |
| PLAN_PARTITIONING_SHARDING.md | PLAN | Research | PostgreSQL partitioning & sharding compatibility |
| PLAN_PACKAGING.md | PLAN | Draft | Distribution packaging |
| PLAN_PG19_COMPAT.md | PLAN | Draft | PostgreSQL 19 forward-compatibility |
| PLAN_DEVCONTAINER_UNIT_TEST_WORKFLOW.md | PLAN | Implemented | Devcontainer unit-test stability and build reuse |
| REPORT_PGWIRE_PROXY.md | REPORT | Research | pgwire proxy / intercept analysis |
| PLAN_PG_BACKCOMPAT.md | PLAN | Research | Supporting older PostgreSQL versions (13–17) |
| PLAN_VERSIONING.md | PLAN | Draft | Semantic versioning & compatibility policy |
| REPORT_BLUE_GREEN_DEPLOYMENT.md | REPORT | Exploration | Blue-green deployment — hot-swap pipelines with zero downtime |
| REPORT_DOWNSTREAM_CONSUMERS.md | REPORT | Exploration | Downstream consumer patterns — getting changes out of stream tables |
| REPORT_ENGINE_COMPOSABILITY.md | REPORT | Proposed | Engine composability and extraction analysis |
| REPORT_FEATURE_COMPOSABILITY.md | REPORT | Exploration | Composability analysis of 7 major features: fuse, watermark, blue-green, sidecar, diamond, cross-source snapshot, transactional IVM |
performance/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_PERFORMANCE_PART_8.md | PLAN | — | Residual bottlenecks & next-wave optimizations |
| PLAN_PERFORMANCE_PART_9.md | PLAN | Planning | Strategic performance roadmap |
| PLAN_MULTI_TABLE_DELTA_BATCHING.md | PLAN | Planned | Multi-table delta batching (B-3) |
| REPORT_PARALLELIZATION.md | REPORT | Planning | Parallelization options analysis |
| STATUS_PERFORMANCE.md | STATUS | — | Performance benchmark history & trends |
| PLAN_TRIGGERS_OVERHEAD.md | PLAN | — | CDC trigger write-side overhead benchmark |
sql/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_CIRCULAR_REFERENCES.md | PLAN | Implemented | Circular references in the dependency graph |
| PLAN_CROSS_SOURCE_SNAPSHOT_CONSISTENCY.md | PLAN | Proposed | Cross-source snapshot consistency for converging independent branches |
| PLAN_DIAMOND_DEPENDENCY_CONSISTENCY.md | PLAN | Decided | Diamond consistency decision: prioritize atomic refresh groups (with aligned mode fallback) |
| PLAN_FUSE.md | PLAN | Exploration | Fuse — halt refresh on anomalous change volume |
| PLAN_LATERAL_JOINS.md | PLAN | Implemented | LATERAL join support (subqueries with LATERAL) |
| PLAN_NON_DETERMINISM.md | PLAN | Not started | Non-deterministic function handling |
| REPORT_CUSTOM_SQL_SYNTAX.md | REPORT | Reference | PostgreSQL extension syntax mechanisms research |
| REPORT_DB_SCHEMA_STABILITY.md | REPORT | Assessment | Database schema stability assessment (pre-1.0) |
| PLAN_HYBRID_CDC.md | PLAN | Complete | Hybrid CDC — trigger bootstrap → logical replication |
| PLAN_BOOTSTRAP_GATING.md | PLAN | Exploration | Bootstrap gating — block downstream refresh until external sources are initially populated |
| PLAN_WATERMARK_GATING.md | PLAN | Exploration | User-provided watermarks for cross-source gating of externally-loaded data |
| PLAN_NATIVE_SYNTAX.md | PLAN | Proposed | Native PostgreSQL syntax for stream tables |
| PLAN_ALTER_QUERY.md | PLAN | Draft | Allow alter_stream_table to change the defining query in place |
| PLAN_REFRESH_MODE_DEFAULT.md | PLAN | Draft | Make refresh mode selection optional with adaptive default behavior |
| PLAN_TRANSACTIONAL_IVM.md | PLAN | Proposed | Transactionally updated views (immediate IVM) |
| PLAN_UPGRADE_MIGRATIONS.md | PLAN | Draft | Extension upgrade migrations |
| PLAN_USER_TRIGGERS_EXPLICIT_DML.md | PLAN | Implemented | User triggers on stream tables via explicit DML |
| PLAN_VIEW_INLINING.md | PLAN | Implemented | View inlining for stream tables |
| GAP_SQL_OVERVIEW.md | GAP | Reference | SQL support gap analysis (periodically updated) |
| REPORT_TRIGGERS_VS_REPLICATION.md | REPORT | Reference | Triggers vs logical replication for CDC |
| PLAN_ORDER_BY_LIMIT_OFFSET.md | PLAN | Not started | Close ORDER BY / LIMIT / OFFSET gaps (incl. TopK) |
| PLAN_OFFSET_SUPPORT.md | PLAN | In progress | Support ORDER BY + LIMIT + OFFSET via TopK scoped recomputation |
| PLAN_PARALLELISM.md | PLAN | Proposed | True parallel refresh within one database via coordinator + dynamic refresh workers |
| GAP_SQL_PHASE_4.md | GAP | Complete | SQL gaps — phase 4 |
| GAP_SQL_PHASE_5.md | GAP | In progress | SQL gaps — phase 5 |
| GAP_SQL_PHASE_6.md | GAP | Reference | SQL gaps — phase 6 (comprehensive analysis) |
| GAP_SQL_PHASE_7.md | GAP | In progress | SQL gaps — phase 7 (deep analysis) |
| GAP_SQL_PHASE_7_QUESTIONS.md | GAP | — | Open questions from GAP_SQL_PHASE_7 |
safety/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_REDUCED_UNSAFE.md | PLAN | Proposed | Reduce unsafe code surface via safe abstractions and macros |
testing/
| File | Type | Status | Summary |
|---|---|---|---|
| PLAN_TEST_SUITES.md | PLAN | Proposed | External test suites for pg_trickle |
| PLAN_TEST_PROPERTY_BASED_INVARIANTS.md | PLAN | Proposed | Ranked expansion plan for property-based and deterministic invariant testing |
| PLAN_TEST_SUITE_TPC_H.md | PLAN | Complete | TPC-H test suite |
| PLAN_TEST_PYRAMID_REBALANCE.md | PLAN | Proposed | Shift coverage down the pyramid — extract unit tests, light-E2E tier |
| STATUS_TESTING.md | STATUS | — | Testing & coverage status |