JSONs are not possible for 10_000_000 records
As hippo says, JSON is just a data format.
Let's give it a try, testing with some generated md5 values:
testdb=# select count(*) from vkon_json;
count
----------
10000000
(1 row)
testdb=# select * from vkon_json limit 3;
js | id
--------------------------------------------+----
{"f1": "c4ca4238a0b923820dcc509a6f75849b"} | 1
{"f1": "c81e728d9d4c2f636f067f89cc14862c"} | 2
{"f1": "eccbc87e4b5ce2fe28308fd9f2a7baf3"} | 3
(3 rows)
-- retrieve:
testdb=# select * from vkon_json
where js @> '{"f1": "d1ca3aaf52b41acd68ebb3bf69079bd1"}';
js | id
--------------------------------------------+----------
{"f1": "d1ca3aaf52b41acd68ebb3bf69079bd1"} | 10000000
(1 row)
Time: 0.679 ms
Less than half a millisecond. What do you think? Possible?
(I could have put everything into a 1-column, 1-row table but that just seems too dumb. Possible, though, and will perform just as fast)
|