PostgreSQL natively indexes JSON data via the JSONB type.
Resolved true The record shows it happened or was so.
Factual: Statements about the present or the past, checked against the record: did they hold up?
What would count as true or false
True: as of 2019-12-24, released PostgreSQL versions supported indexing jsonb columns with built-in index types (e.g. GIN with jsonb_ops or jsonb_path_ops, or B-tree/expression indexes) and no third-party extension. Mostly true: native jsonb indexing existed but with a minor caveat in how it is described, e.g. it requires an explicit GIN index rather than happening automatically. Mixed or mostly false: indexing jsonb required extensions or worked only in limited ways. False: PostgreSQL had no jsonb type or no native way to index it at that date.
Set before the research began.
Evidence (4)
-
E1 8.14. JSON Types PostgreSQL Global Development Group (postgresql.org, PostgreSQL 11 documentation)
“The default GIN operator class for jsonb supports queries with top-level key-exists operators ?, ?& and ?| operators and path/value-exists operator @>.”
-
E2 8.14. JSON Types PostgreSQL Global Development Group (postgresql.org, PostgreSQL 11 documentation)
“The non-default GIN operator class jsonb_path_ops supports indexing the @> operator only. An example of creating an index with this operator class is:”
-
E3 8.14. JSON Types PostgreSQL Global Development Group (postgresql.org, PostgreSQL 11 documentation)
“jsonb also supports btree and hash indexes. These are usually useful only if it's important to check equality of complete JSON documents.”
-
E4 Release 9.4 PostgreSQL Global Development Group (postgresql.org, release notes) · 18 December 2014
“This new type allows faster access to values within a JSON document, and faster and more useful indexing of JSON columns.”
Reasoning
The PostgreSQL 9.4 release notes, dated 2014-12-18 (E4), introduced the jsonb type and describe "faster and more useful indexing of JSON columns". That was five years before the claim date. The PostgreSQL 11 documentation (E1–E3) describes built-in index support for jsonb: the default GIN operator class, the jsonb_path_ops GIN operator class, and btree and hash indexes. None of these needs a third-party extension. The user has to create these indexes explicitly, but the quote does not say indexing happens automatically, so the claim meets the criteria for true.
Cite this claim
Balaji Srinivasan, “PostgreSQL natively indexes JSON data via the JSONB type.” (said 24 December 2019). Verdict: resolved true. Reliability API, claim c_233f5ba6efa7, method 0.1.0+c876030c, dataset release v1.1.2. https://epistacklabs.com/claims/c_233f5ba6efa7
This claim is in dataset release v1.1.2, with the same verdict.
Reply to this claim
More factual claims by Balaji Srinivasan
-
Mostly false
“Electric vehicles now fill up roughly as fast as gas.”
Electric vehicles now fill up roughly as fast as gasoline vehicles.
-
Mixed
“It's really the keys to your car itself. The digital signature starts the engine.”
The keys are the keys to the car itself: a digital signature starts the engine.
-
Mostly true
“this door can also be secured with an onchain smart lock. That means the door to your house can be secured by crypto.”
Doors, including house doors, can be secured with an onchain smart lock controlled by crypto.
-
Mostly true
“in the late ’90s, and probably the early 2000s, people talked about the so-called convergence device.”
-
Resolved true
“Sergey Brin, many years ago, remarked that it was emasculating to do that.”
Sergey Brin remarked many years ago that staring down at a phone is emasculating.
Verdicts are made automatically; how verdicts are made.