JSONB indexing

5 posts about JSONB indexing by 3 contributors.

Know JSONB indexing? Share what you know with developers who are learning it.

Write an article Ask a question

+ Follow JSONB indexingBe the first to follow this

Articles: 5
Contributors: 3

Articles about JSONB indexing

Article · PostgreSQL
PostgreSQL JSON vs. JSONB: Which One Should You Use?
Compare PostgreSQL JSON and JSONB storage, querying, duplicate-key behavior, and indexing to choose the right type for your application.
Nidhi SharmaOct 222,8771,000

Article · PostgreSQL

PostgreSQL JSONB Indexes: When to Use GIN and When to Use B-Tree

Learn when to use GIN or B-tree indexes for PostgreSQL JSONB queries, including expression indexes, containment operators, and operator classes.

Nidhi SharmaOct 223,2181,000

Article · PostgreSQL

PostgreSQL JSONB: How to Handle Different Attributes for Thousands of SKUs

Learn how to use PostgreSQL JSONB for flexible product attributes, including GIN indexing, JSONB queries, and .NET EF Core integration for product search.

Ng CheehouSep 142,6091,000

Article · PostgreSQL

PostgreSQL 19 Beta 3: Detecting Query Regressions in EF Core Applications

Learn how to benchmark EF Core queries on PostgreSQL 19 Beta 3, compare them with PostgreSQL 18, and investigate regressions using generated SQL and execution plans.