aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-11-01 20:05:16 -0700
committerBryan Newbold <bnewbold@archive.org>2021-11-04 17:19:52 -0700
commit4315b44a93ca31725b9b0a2a55c310725ac55efe (patch)
treeb8d7018b639651f3e241d098962866f41d2c6cd6 /sql
parent2e9cd60819531ad73ce71f3a84109ad164624a40 (diff)
downloadsandcrawler-4315b44a93ca31725b9b0a2a55c310725ac55efe.tar.gz
sandcrawler-4315b44a93ca31725b9b0a2a55c310725ac55efe.zip
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.
Diffstat (limited to 'sql')
-rw-r--r--sql/migrations/2019-12-19-060141_init/up.sql2
1 files changed, 1 insertions, 1 deletions
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)
);