JSONB Tricks: Operators, Indexes, and When to (Not) Use It | PostgresOpen 2019 | Colton Shepard

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
September 12, 2019

JSONB Tricks: Operators, Indexes, and When to (Not) Use It | PostgresOpen 2019 | Colton Shepard

When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up.

In this talk, you will get details on these topics, complete with practical examples and real-world stories:

1. When to use jsonb, what it’s good for, and when to not use it
2. Operators and how to use them effectively
3. Indexing, operator support for indexes, and the tradeoffs involved
4. Postgres 12 improvements and new features

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

September 12, 2019
Tweet