Niklas Schmidtmer

The example was overly simplified, in reality, there are sequences such as this where `DO NOTHING` is not applicable: ```sql -- start: Table is empty -- succeeds, 1 row inserted...

For the second case, I can provide some performance details. The table is defined as: ```sql CREATE TABLE t1 ( "measurement_id" VARCHAR(256) NOT NULL, "type" VARCHAR(256) NOT NULL, "metric_id" VARCHAR(256)...

One more example is this `MAX` query: ```sql SELECT MAX(ts) FROM metric; ``` Table structure: ```sql CREATE TABLE "metric" ( "ts" TIMESTAMP WITH TIME ZONE, "g_ts_month" TIMESTAMP WITH TIME ZONE...

> check if `SELECT "Vector" FROM "WayveScenesVectors";` causes OOM? I would like to rule out `GEO_POINT` if possible. Yes, omitting all columns but `Vector` still leads to an OOM.

> It looks like CrateDB's `ALTER TABLE ... ADD COLUMN ... DEFAULT`, despite different to PostgreSQL, currently has the same semantics that could help you here? Here we are looking...

Thanks for the additional background information on what can cause the shard locks. It can very well be that this is a consequence of https://github.com/crate/crate/issues/18721 (the customer reporting that issue...