Remix.run Logo
inigyou a day ago

Postgres does even better and it's available right now. No virtual column needed.

    CREATE TABLE t1 (data JSONB);
    INSERT INTO t1 VALUES ('{"column1":1234}');
    CREATE INDEX t1column1 ON t1(data->'column1');
    SELECT * FROM t1 WHERE data1->'column1' = '1234'; // not sure about data type
mathnode a day ago | parent [-]

I would not call an index format which gets slower with growth "better". And that vacuum issue on JSONB scales with your data size.

inigyou a day ago | parent [-]

What do you mean slower with growth? What vacuum issue?

sgt 13 hours ago | parent [-]

[flagged]