You want to speed up full-text search on a JSONB column data containing text under key description. How do you create a GIN index for this?

hard📝 Application Q8 of 15

PostgreSQL - Full-Text Search

You want to speed up full-text search on a JSONB column data containing text under key description. How do you create a GIN index for this?

ACREATE INDEX idx_data_desc ON items USING BTREE (data->>'description');

BCREATE INDEX idx_data_desc ON items USING GIN (data);

CCREATE INDEX idx_data_desc ON items USING GIN (to_tsvector('english', data->>'description'));

DCREATE INDEX idx_data_desc ON items USING HASH (to_tsvector('english', data));

Step-by-Step Solution

Solution:

Step 1: Extract text from JSONB
Use data->>'description' to get text from JSONB.
Step 2: Create GIN index on to_tsvector of extracted text
Apply to_tsvector with 'english' config for full-text search.
Final Answer:
CREATE INDEX idx_data_desc ON items USING GIN (to_tsvector('english', data->>'description')); -> Option C
Quick Check:
GIN index on to_tsvector of JSONB text = CREATE INDEX idx_data_desc ON items USING GIN (to_tsvector('english', data->>'description')); [OK]

Quick Trick: Extract JSONB text then apply to_tsvector for GIN index [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free