ClaimsBalaji Srinivasan

“Postgres indexes it natively these days with JSONB!”

Balaji Srinivasan, writing on X 24 December 2019 Post by @balajis on X, 2019-12-24 (X)

Factual Technology

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)

  1. 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 @>.”
  2. 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:”
  3. 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.”
  4. 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

For Balaji Srinivasan, or someone speaking for them: a correction or counter-evidence. Replies are read before anything is shown; an approved reply shows your name, role, date, statement and link. Your email address is never shown and is deleted 30 days after the decision (privacy).

More factual claims by Balaji Srinivasan

  1. Mostly false Factual 22 December 2025
    “Electric vehicles now fill up roughly as fast as gas.”

    Electric vehicles now fill up roughly as fast as gasoline vehicles.

  2. Mixed Factual 28 July 2025
    “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.

  3. Mostly true Factual 28 July 2025
    “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.

  4. Mostly true Factual 4 July 2022
    “in the late ’90s, and probably the early 2000s, people talked about the so-called convergence device.”

    In the late 1990s, and probably the early 2000s, people (including Bill Gates) talked about a 'convergence device'.

  5. Resolved true Factual 4 July 2022
    “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.

All of them

Verdicts are made automatically; how verdicts are made.