joshua-spacetime

A predicate such as `x = 0 and y = 1` can be answered by an index on `{x,y,z}` On `z`, you would use the infinite range.

Requirements: - Initial subscription and ad hoc queries whose estimated energy consumption exceeds limit will fail before being executed - The energy limit should be configurable at runtime - We...

perf(query eval): change `ColumnOp` to use row positions instead of field names + allocate less in the common case

2

Expression evaluation accounts for over a third of incremental query evaluation for certain performance benchmarks  We should introduce a more optimized version of `ColumnOp`. This more optimal representation should...

Store table row size in system table

3

Ideally this would be a column in `st_table`, but I don't think we want to change the schema of `st_table`. It could also be a view over `st_columns`, but in...

Add request context to datastore traits

1

Currently, once a transaction has started, it will run till completion. There is no way to stop its execution. The datastore traits need some sort of request context that can...

Update incremental subscription benchmarks to include row serialization

2

Currently the incremental subscription benchmarks, `incr-join` and `incr-select`, only take into account query execution. They should also include row serialization. Specifically they should include both the cost of serializing product...

Slow query log per module

1

https://github.com/clockworklabs/SpacetimeDB/issues/1071 captures slow queries through the SpacetimeDB server logs. Now we should give users the same insight with a slow query system table. They should be able to configure the...

Mutable transactions should be downgradable

1

This is specifically related to subscriptions. Subscriptions are very similar to materialized views (matviews). Like matviews, they need access to the database, because they depend on both the row updates...

- New CI task which can be executed as part of CI - Automatic flamegraph generation

Track memory usage for tables in grafana & track energy for persistent database memory

3

We should track the persistent memory associated with tables and indexes for energy purposes. This means each table and index needs access to an `EnergyMonitor` for recording energy use. If...