From 4315b44a93ca31725b9b0a2a55c310725ac55efe Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 1 Nov 2021 20:05:16 -0700 Subject: sql: grobid_refs table JSON as 'JSON' not 'JSONB' I keep flip-flopping on this, but our disk usage is really large, and if 'JSON' is smaller than 'JSONB' in postgresql at all it is worth it. --- sql/migrations/2019-12-19-060141_init/up.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/migrations') diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index 254c08a..18972cb 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -225,7 +225,7 @@ CREATE TABLE IF NOT EXISTS grobid_refs ( source_id TEXT NOT NULL CHECK (octet_length(source_id) >= 1), source_ts TIMESTAMP WITH TIME ZONE, updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, - refs_json JSONB NOT NULL, + refs_json JSON NOT NULL, PRIMARY KEY(source, source_id) ); -- cgit v1.2.3