HeliosDB Full — Feature Matrix
Version: 7.2.0 | Crates: 193 (28 parent groups) | License: Apache-2.0
Last Updated: 2026-03-06
Legend: W = Working | P = Partial | S = Stub/Experimental | — = Not Implemented
1. SQL Language Support
DML Operations
| Feature | Status | E2E Verified | Notes |
|---|
| SELECT (simple) | W | Yes | Projections, WHERE, LIMIT, OFFSET |
| SELECT (expressions) | W | Yes | CASE, COALESCE, arithmetic, functions on columns |
| INSERT (single row) | W | Yes | Direct values and expressions |
| INSERT (multi-row) | W | Yes | Batch insert VALUES (…), (…) |
| INSERT … RETURNING | W | Yes | Return inserted row values |
| UPDATE | W | Yes | SET with WHERE, expression assignments |
| DELETE | W | Yes | With WHERE clause |
| MERGE | P | No | PostgreSQL 17-style MERGE (parser preprocessing) |
| UPSERT / ON CONFLICT | W | Yes | DO NOTHING and DO UPDATE SET |
| COPY | P | No | Via datapump engine |
Query Clauses
| Feature | Status | E2E Verified | Notes |
|---|
| WHERE | W | Yes | Complex boolean expressions, AND/OR/NOT |
| GROUP BY | W | Yes | Single, multi-column, and expression (e.g., GROUP BY UPPER(col)) |
| HAVING | W | Yes | Post-aggregate filtering, multiple AND conditions |
| ORDER BY | W | Yes | ASC/DESC, multi-column, NULLS FIRST/LAST |
| LIMIT / OFFSET | W | Yes | Pagination |
| DISTINCT | W | Yes | SELECT DISTINCT, COUNT(DISTINCT col), multi-column |
| UNION / UNION ALL | W | Yes | Set union with/without deduplication |
| INTERSECT / EXCEPT | W | Yes | Set intersection and difference |
JOIN Operations
| Feature | Status | E2E Verified | Notes |
|---|
| INNER JOIN | W | Yes | ON condition, multi-column |
| LEFT [OUTER] JOIN | W | Yes | NULL-preserving left |
| RIGHT [OUTER] JOIN | W | Yes | NULL-preserving right |
| FULL OUTER JOIN | W | Yes | Combined left+right |
| CROSS JOIN | W | Yes | Cartesian product + implicit (FROM a, b) |
| Self-Join | W | Yes | With table aliases, NULL key handling |
| Multi-table JOIN | W | Yes | 3+ table chains |
| JOIN with aggregates | W | Yes | GROUP BY on joined results |
| JOIN with NULL keys | W | Yes | NULL != NULL in join conditions |
Aggregate Functions
| Feature | Status | E2E Verified | Notes |
|---|
| COUNT(*) | W | Yes | O(1) fast path via pk_index |
| COUNT(col) | W | Yes | NULL exclusion |
| COUNT(DISTINCT col) | W | Yes | Distinct set tracking, in GROUP BY context |
| SUM(col) | W | Yes | Incremental accumulation |
| AVG(col) | W | Yes | SUM/COUNT derivation |
| MIN(col) | W | Yes | Numeric + string comparison |
| MAX(col) | W | Yes | Numeric + string comparison |
| SUM(expression) | W | Yes | e.g., SUM(price * quantity) |
| Conditional aggregate | W | Yes | SUM(CASE WHEN … THEN … END) |
Window Functions
| Feature | Status | E2E Verified | Notes |
|---|
| ROW_NUMBER() | W | Yes | Sequential numbering |
| RANK() | W | Yes | Gap-producing rank |
| DENSE_RANK() | W | Yes | No-gap rank |
| LAG() / LEAD() | W | Yes | Row offset access with defaults |
| NTILE() | W | Yes | N-bucket distribution |
| SUM/AVG/COUNT OVER | W | Yes | Aggregate windows |
| PARTITION BY | W | Yes | Window partitioning |
| ORDER BY in windows | W | Yes | Independent of query ORDER BY |
| Frame clauses | P | No | Parser support; limited execution |
Subqueries & CTEs
| Feature | Status | E2E Verified | Notes |
|---|
| IN (subquery) | W | Yes | Scalar subquery membership |
| NOT IN (subquery) | W | Yes | Negated membership |
| EXISTS (subquery) | W | Yes | Existence check |
| Scalar subquery | W | Yes | Single-value subquery in WHERE |
| CTE (WITH clause) | W | Yes | Non-recursive CTEs |
| Recursive CTE | W | Yes | WITH RECURSIVE for hierarchical/series queries |
Operators & Functions
| Feature | Status | E2E Verified | Notes |
|---|
| Comparison (=, !=, <, >, <=, >=) | W | Yes | Numeric + string |
| BETWEEN | W | Yes | Range matching |
| IN / NOT IN | W | Yes | List membership |
| LIKE / ILIKE | W | Yes | Pattern matching with % and _ |
| IS NULL / IS NOT NULL | W | Yes | Null checks |
| CAST / :: | W | Yes | Type conversion including BOOLEAN extended matching |
| CASE WHEN | W | Yes | Searched and simple CASE, on columns and in aggregates |
| JSON -> (get field) | W | Yes | JSON object field extraction |
| JSON ->> (get text) | W | Yes | JSON field as text |
| String functions | W | Yes | UPPER, LOWER, LENGTH, TRIM, LTRIM, RTRIM, SUBSTRING, CONCAT/||, REPLACE, POSITION, LEFT, RIGHT, REPEAT, REVERSE |
| Math functions | W | Yes | ABS, ROUND, CEIL, FLOOR, MOD, POWER, SQRT |
| Date/time functions | W | Yes | NOW, CURRENT_TIMESTAMP, CURRENT_DATE, EXTRACT(YEAR/MONTH/DAY), DATE_TRUNC |
| COALESCE / NULLIF | W | Yes | On literals and column data |
2. DDL Operations
| Feature | Status | E2E Verified | Notes |
|---|
| CREATE TABLE | W | Yes | Full schema, column constraints |
| CREATE TABLE IF NOT EXISTS | W | Yes | Idempotent creation |
| DROP TABLE | W | Yes | With IF EXISTS |
| DROP TABLE CASCADE | W | Yes | Cascading drop |
| TRUNCATE TABLE | W | Yes | Fast table clearing |
| ALTER TABLE | W | Yes | ADD COLUMN, DROP COLUMN, RENAME COLUMN |
| CREATE VIEW | W | Yes | CREATE OR REPLACE VIEW, DROP VIEW IF EXISTS |
| CREATE INDEX | W | Yes | B-Tree, Hash, partial, expression indexes |
| CREATE INDEX CONCURRENTLY | W | Yes | Non-blocking index creation |
| CREATE UNIQUE INDEX | W | Yes | Uniqueness enforcement |
| DROP INDEX | W | Yes | Index removal with IF EXISTS |
| REINDEX | W | Yes | REINDEX TABLE and REINDEX INDEX |
| CREATE EXTENSION | W | No | Extension management |
3. Data Types
Scalar Types
| Type | PG OID | Status | E2E Verified | Notes |
|---|
| SMALLINT / INT2 | 21 | W | Yes | 2-byte integer |
| INTEGER / INT4 | 23 | W | Yes | 4-byte integer |
| BIGINT / INT8 | 20 | W | Yes | 8-byte integer |
| REAL / FLOAT4 | 700 | W | Yes | 4-byte float |
| DOUBLE PRECISION / FLOAT8 | 701 | W | Yes | 8-byte float |
| NUMERIC / DECIMAL | 1700 | W | Yes | Arbitrary precision |
| BOOLEAN | 16 | W | Yes | true/false |
| TEXT | 25 | W | Yes | Unlimited text |
| VARCHAR(n) | 1043 | W | Yes | Variable-length |
| CHAR(n) | 18 | W | Yes | Fixed-length |
| BYTEA | 17 | W | Yes | Binary data (hex format) |
| DATE | 1082 | W | Yes | Date only |
| TIME | 1083 | W | Yes | Time only |
| TIMESTAMP | 1114 | W | Yes | Without timezone |
| TIMESTAMPTZ | 1184 | W | Yes | With timezone |
| JSON | 114 | W | Yes | JSON text |
| JSONB | 3802 | W | Yes | JSON binary |
| UUID | 2950 | W | Yes | 128-bit identifier |
| SERIAL / BIGSERIAL | — | W | Yes | Auto-increment with sequence tracking |
Array Types
| Type | PG OID | Status | E2E Verified | Notes |
|---|
| INTEGER[] | 1007 | W | Yes | 1D and 2D arrays |
| BIGINT[] | 1016 | W | No | Int8 arrays |
| SMALLINT[] | 1005 | W | No | Int2 arrays |
| TEXT[] | 1009 | W | Yes | Text arrays |
| VARCHAR[] | 1015 | W | No | Varchar arrays |
| BOOLEAN[] | 1000 | W | No | Bool arrays |
| FLOAT4[] | 1021 | W | No | Float arrays |
| FLOAT8[] | 1022 | W | No | Double arrays |
4. Constraints
| Feature | Status | E2E Verified | Notes |
|---|
| PRIMARY KEY | W | Yes | Column and table-level |
| UNIQUE | W | Yes | Column and table-level |
| NOT NULL | W | Yes | Null rejection at INSERT |
| DEFAULT | W | Yes | Column defaults |
| CHECK | P | No | Parsed; enforcement incomplete |
| FOREIGN KEY | P | No | Parsed; referential integrity incomplete |
5. Transaction Support
| Feature | Status | E2E Verified | Notes |
|---|
| BEGIN / START TRANSACTION | W | Yes | Explicit transactions |
| COMMIT | W | Yes | Durable commit |
| ROLLBACK | W | Yes | Full undo with pk_index/cache cleanup |
| SAVEPOINT | W | Yes | Named savepoints |
| ROLLBACK TO SAVEPOINT | W | Yes | Partial undo |
| RELEASE SAVEPOINT | W | Yes | Savepoint release |
| READ COMMITTED isolation | W | Yes | Default level |
| REPEATABLE READ isolation | W | Yes | Snapshot-based |
| SERIALIZABLE isolation | W | Yes | SSI (per-connection coordinator) |
| Cross-connection MVCC | W | Yes | Shared uncommitted_keys for isolation |
| Autocommit mode | W | Yes | Default on; toggle with SET |
| 2-Phase Commit (2PC) | W | No | Distributed transactions |
| XA Transactions | W | No | X/Open XA support |
6. Procedural & Triggers
| Feature | Status | E2E Verified | Notes |
|---|
| CREATE FUNCTION (SQL) | W | Yes | SQL language UDFs |
| CREATE FUNCTION (PL/pgSQL) | W | Yes | Full PL/pgSQL interpreter |
| CREATE PROCEDURE | W | Yes | Procedure creation |
| DROP FUNCTION/PROCEDURE | W | Yes | With IF EXISTS |
| CALL statement | W | Yes | Procedure invocation |
| Function overloading | W | Yes | Same name, different parameter types |
| Table-returning functions | W | Yes | RETURNS TABLE with RETURN QUERY |
| Default parameters | W | Yes | param type DEFAULT value |
| PL/pgSQL: DECLARE | W | Yes | Variable declaration with types |
| PL/pgSQL: IF/ELSIF/ELSE | W | Yes | Conditional branching |
| PL/pgSQL: WHILE LOOP | W | Yes | Loop control |
| PL/pgSQL: RETURN / RETURN QUERY | W | Yes | Value and table return |
| PL/pgSQL: SELECT INTO | W | Yes | Variable assignment from queries |
| PL/pgSQL: EXCEPTION WHEN | W | Yes | Error handling |
| SECURITY DEFINER / IMMUTABLE | W | Yes | Stripped before parsing |
| BEFORE INSERT trigger | W | Yes | Via TriggerEngine |
| AFTER INSERT trigger | W | Yes | Via TriggerEngine |
| BEFORE UPDATE trigger | W | Yes | Via TriggerEngine |
| DROP TRIGGER | W | Yes | Trigger removal |
| WASM stored procedures | W | No | Polyglot (Rust/JS/Python/Go) |
7. Protocol Adapters (14 Protocols)
| Protocol | Port | Status | Wire Protocol | Auth |
|---|
| PostgreSQL | 5432 | W | Wire v3.0, Simple+Extended query | SCRAM-SHA-256 |
| MySQL | 3306 | W | MySQL text/binary protocol | SHA-256 |
| MongoDB | 27017 | W | BSON wire protocol | SCRAM |
| Redis | 6379 | W | RESP protocol | Password |
| Oracle | 1521 | W | TNS protocol | Username/password |
| SQL Server (TDS) | 1433 | W | TDS protocol | SQL auth |
| DB2 (DRDA) | 50000 | W | DRDA protocol | Username/password |
| Cassandra (CQL) | 9042 | W | CQL v4 native | Username/password |
| ClickHouse | 9000 | W | Native TCP protocol | Username/password |
| Snowflake | — | W | SQL REST API | Token/JWT |
| Databricks | — | W | Delta/SQL API | Token |
| Pinecone | — | W | Vector REST API | API key |
| HTTP Gateway | 18443 | W | REST + JSON | JWT/Bearer/API key |
| GraphQL | 18443 | W | GraphQL endpoint | JWT/Bearer |
HTTP API Gateway
| Endpoint | Method | Status | E2E Verified | Notes |
|---|
| /api/v1/query | POST | W | Yes | Execute SQL, return JSON |
| /query | POST | W | Yes | Alias for /api/v1/query |
| /health, /healthz | GET | W | Yes | Health check |
| /ready, /readyz | GET | W | Yes | Readiness check |
| /status, /api/v1/status | GET | W | Yes | Server status |
8. Storage Engine
| Feature | Status | Module | Notes |
|---|
| LSM-Tree | W | lsm.rs | Leveled compaction, k-way merge |
| B-Tree Indexes | W | btree_index.rs | MVCC-aware, SIMD search, latch coupling |
| WAL (Write-Ahead Log) | W | wal.rs | fsync, group commit |
| Commit Log | W | commitlog.rs | Replay on recovery |
| MVCC | W | mvcc_snapshot_manager.rs | Snapshot isolation |
| SSI (Serializable) | W | transaction_manager_ssi.rs | Serializable Snapshot Isolation |
| Compaction | W | compaction_v2.rs | Leveled + size-tiered |
| HCC Compression | W | hcc_sstable.rs | 10x compression ratios |
| PITR | W | pitr.rs | Point-in-time recovery |
| Temporal Tables | W | temporal_sql.rs | SQL:2011 standard |
| Cloud Tiering | W | s3_backend.rs, gcs_backend.rs | S3/GCS/Azure |
| Data Integrity | W | integrity/ | Checksums, corruption detection, auto-repair |
| Full/Incremental Backup | W | backup*.rs | Full, incremental, differential |
9. Exadata-Parity Modules
| Phase | Feature | Status | Module |
|---|
| 1 | Zone Maps | W | zone_map.rs |
| 1 | Smart Scan | W | smart_scan.rs |
| 1 | Columnar Block | W | columnar_block.rs |
| 1 | Filters | W | filters.rs |
| 1 | IMCS (In-Memory Column Store) | W | imcs.rs |
| 2 | Direct I/O WAL | W | direct_io_wal.rs |
| 2 | Lock-Free Ingestion | W | lockfree_ingestion.rs |
| 2 | Parallel WAL | W | parallel_wal.rs |
| 2 | SMFI | W | smfi.rs |
| 2 | MV Refresh | W | mv_refresh.rs |
| 2 | Stored Procedures | W | stored_procedures.rs |
| 2 | Triggers | W | triggers.rs |
| 2 | Tiered Cache | W | tiered_cache.rs |
| 2 | HTAP API | W | htap_api.rs |
| 3 | IO-Uring Transport | W | io_uring_transport |
| 3 | RDMA Transport | W | rdma_transport |
| 3 | IORM | W | iorm.rs |
| 3 | PMEM WAL | W | pmem_wal.rs |
| 3 | Distributed Smart Scan | W | distributed_smart_scan.rs |
| 4 | Cache Fusion | W | cache_fusion |
| 4 | DIME | W | dime.rs |
| 4 | Workload Capture | W | workload_capture |
| 4 | Enhanced Optimizer | W | enhanced_optimizer.rs |
| 4 | Multi-Protocol Smart Scan | W | multi_protocol_smart_scan.rs |
10. Query Engine & Optimization
| Feature | Status | Module | Notes |
|---|
| Cost-Based Optimizer v2 | W | cost-optimizer-v2 | Statistics-driven planning |
| Distributed Optimizer | W | distributed-optimizer | Cross-node plans |
| Semantic Optimizer | W | semantic-optimizer | Logical rewriting |
| Predicate Pushdown | W | predicate_pushdown_v2.rs | Early filtering |
| Column Pruning | W | column-pruning | Unused column elimination |
| Join Reordering | W | join_reordering.rs | Optimal join order |
| Cardinality Estimation | W | cardinality | Row count prediction |
| Parallel Query | W | parallel-query | Multi-threaded execution |
| Parallel Aggregation | W | parallel-agg | Distributed GROUP BY |
| Materialized Views | W | materialized-views | Query rewriting |
| Query Hints | W | query-hints | User-guided optimization |
| Query Progress | W | query-progress | Real-time tracking |
| Query Advisor | W | query-advisor | Optimization recommendations |
| SIMD Expression Eval | W | simd_executor.rs | AVX2 vectorized filters |
| JIT Compilation | W | jit_compiler.rs | Cranelift native JIT |
| EXPLAIN (7 formats) | W | handler.rs | TEXT/JSON/YAML/XML/HTML/GraphViz/Mermaid |
11. Security
| Feature | Status | Module | Notes |
|---|
| SCRAM-SHA-256 (PG) | W | handler.rs | PostgreSQL wire auth |
| JWT Authentication | W | auth/ | Token-based auth |
| API Key Auth | W | auth/ | Per-key scoping |
| RBAC | W | rbac/ | Role-Based Access Control |
| ABAC | W | abac/ | Attribute-Based Access Control |
| TDE | W | encryption/ | AES-256-GCM/CTR, ChaCha20 |
| HSM/KMS Integration | W | encryption/ | PKCS#11, AWS KMS, Azure Key Vault |
| PQC | W | pqc/ | Post-Quantum Cryptography |
| SSO / LDAP | W | sso/, ldap/ | Single Sign-On, LDAP directory |
| SQL Injection Prevention | W | sql_security.rs | Input validation + heuristic detection |
| Row/Column-Level Security | W | rbac/ | Fine-grained access control |
| Audit Logging | W | audit/ | Access audit trail |
| CREATE ROLE/USER | W | handler.rs | Role management via SQL |
| GRANT / REVOKE | W | handler.rs | Permission management |
12. Cluster & Distribution
| Feature | Status | Module | Notes |
|---|
| Raft Consensus | W | heliosdb-cluster | Leader election, log replication |
| Multi-Master | W | multi-master | Active-active replication |
| Sharding | W | sharding | Consistent hash partitioning |
| Adaptive Routing | W | adaptive-routing | Workload-based routing |
| Automated Failover | W | cluster | Sub-second failover |
| CDC (Change Data Capture) | W | replication/cdc | Stream data changes |
| Multi-Region | W | multiregion | Cross-region replication |
| SafeKeeper | W | safekeeper | Write redundancy |
13. AI / ML / Vector
| Feature | Status | Module | Notes |
|---|
| NL2SQL | W | heliosdb-nl | Natural language to SQL |
| NL2Graph | W | heliosdb-nl | Natural language to Cypher/GQL |
| HNSW Vector Index | W | heliosdb-vector | Billion-scale ANN search |
| Hybrid Search | W | hybrid-search | Vector + BM25 keyword |
| RAG | W | rag | Retrieval-Augmented Generation |
| ML Training | W | ml-training | In-database model training |
| Cognitive Agents | W | cognitive-agents | AI-driven autonomous management |
| Neural Planner | W | neural-planner | ML query optimization |
| Anomaly Detection | W | anomaly-detection | Statistical + ML outlier detection |
| Forecasting | W | forecasting | ARIMA, Prophet, LSTM |
| AutoML Tuning | W | automl-tuning | Automated hyperparameter tuning |
| Privacy-ML | W | privacy-ml | Federated learning, differential privacy |
14. Data Models
| Model | Status | Module | Notes |
|---|
| Relational (SQL) | W | Core | Standard tables and queries |
| Document (MongoDB) | W | document | JSON/BSON documents |
| Graph (Cypher/GQL) | W | graph, gql | Property graph model |
| Geospatial | W | geospatial | PostGIS-style spatial |
| Probabilistic | W | probabilistic | Bloom, HLL, Count-Min |
| Multi-Model Unified | W | multi-model | Cross-model queries |
15. Observability & Operations
| Feature | Status | Module | Notes |
|---|
| OpenTelemetry | W | heliosdb-observability | Distributed tracing |
| Prometheus Metrics | W | prometheus_metrics.rs | Metrics export |
| Grafana Dashboards | W | deployment/monitoring/ | Pre-built dashboards |
| Slow Query Logging | W | handler.rs | Configurable threshold (1s default) |
| EXPLAIN ANALYZE | W | handler.rs | Runtime metrics |
| Performance Tracing | W | perf_span! macro | Zero-cost when disabled |
16. Deployment & Infrastructure
| Feature | Status | Location | Notes |
|---|
| Docker | W | Dockerfile | Multi-stage Rust 1.85 build |
| Docker Compose | W | docker-compose.yml | Multi-service orchestration |
| GitHub Actions CI | W | .github/workflows/ci.yml | Check, clippy, test, build, docker |
| Kubernetes | W | deployment/kubernetes/ | K8s manifests |
| Terraform | W | deployment/terraform/ | IaC |
| Ansible | W | deployment/ansible/ | Config management |
| Helm Chart | W | deployment/ | Helm packaging |
17. Autonomous Features
| Feature | Status | Module | Notes |
|---|
| Auto-Indexing | W | auto-index | Automatic index creation |
| Self-Healing | W | self-healing | Automatic failure recovery |
| Adaptive Tuning | W | adaptive, autonomous-tuning | Workload-based parameter tuning |
| Workload Capture | W | workload | Recording and replay |
| Data Quality | W | data-quality | Quality monitoring |
| Predictive Scaling | W | scaling | ML-based scaling |
18. Research & Experimental
| Feature | Status | Module | Notes |
|---|
| Quantum Optimizer | S | research/quantum | Quantum-inspired query optimization |
| GPU Acceleration | S | gpu_executor.rs | CUDA/ROCm compute |
| Neuromorphic | S | research/neuromorphic | Brain-inspired computation |
| Blockchain-CRDT | S | research/blockchain-crdt | Immutable ledger + eventual consistency |
| Genomics | S | research/genomics | DNA sequence search |
19. Branching & Time-Travel
| Feature | Status | E2E Verified | Notes |
|---|
| CREATE DATABASE BRANCH | W | No | Isolated data branches |
| USE BRANCH | W | No | Session branch binding |
| MERGE DATABASE BRANCH | W | No | Branch merge |
| DROP DATABASE BRANCH | W | No | Branch removal |
| ALTER DATABASE BRANCH | W | No | Branch modification |
| Branch-aware GC | W | No | Version cleanup respects branches |
20. E2E Test Results (2026-03-06)
245 / 247 tests pass (99.2%) | 0 failures | 2 skipped
| Test File | Category | Passed | Skipped | Failed |
|---|
| test_basic_crud.py | CRUD Operations | 20 | 0 | 0 |
| test_aggregates.py | Aggregates | 24 | 0 | 0 |
| test_data_types.py | Data Types | 22 | 0 | 0 |
| test_indexes.py | Indexes | 20 | 0 | 0 |
| test_joins.py | JOINs | 15 | 0 | 0 |
| test_advanced_sql.py | Advanced SQL | 17 | 0 | 0 |
| test_procedures.py | Procedures/Triggers | 18 | 0 | 0 |
| test_transactions.py | Transactions | 16 | 0 | 0 |
| test_hardening.py | Hardening | 73 | 2 | 0 |
| test_http_api.py | HTTP API | 20 | 0 | 0 |
| TOTAL | | 245 | 2 | 0 |
Skipped Tests (2)
| Test | Reason |
|---|
| test_check_constraint_rejects_invalid | CHECK constraints parsed but not enforced at INSERT time |
| test_date_arithmetic | DATE + INTERVAL arithmetic not yet supported |
Previously Failing (Now Fixed)
| Test | Fix Applied |
|---|
| test_autocommit_off | Cross-connection MVCC via shared uncommitted_keys |
| test_transaction_isolation_between_connections | Cross-connection MVCC |
Previously Skipped (Now Passing)
| Category | Count | Fix Applied |
|---|
| Stored Procedures (PL/pgSQL) | 14 | Full PL/pgSQL interpreter: DECLARE, IF/ELSIF, WHILE, RETURN, SELECT INTO, exceptions |
| Triggers (BEFORE/AFTER) | 4 | TriggerEngine wired to INSERT/UPDATE/DELETE execution path |
| REINDEX | 2 | REINDEX TABLE and REINDEX INDEX implementation |
21. Performance vs PostgreSQL 16.11 (2026-02-15)
| Operation | HeliosDB (Python) | PostgreSQL | Speedup |
|---|
| Point Lookup | 75 us | 132 us | 1.8x |
| Full Scan | 323 us | 859 us | 2.7x |
| Aggregates | 55 us | 148 us | 2.7x |
| INSERT | 75 us | 481 us | 6.4x |
| UPDATE | 83 us | 466 us | 5.6x |
| DELETE | 70 us | 450 us | 6.5x |
| Mixed OLTP | 82 us | 271 us | 3.3x |
Score: HeliosDB wins 7/7 benchmarks
Part of the HeliosDB Full workspace.
