Choose PostgreSQL Indexing Strategies | Dataford Interview Questions

A PostgreSQL system contains entity, record, and event data with JSONB attributes, status values, and timestamp-based access patterns. Create the recommended indexes for these workload patterns, then return their catalog definitions.

Output

Return one row per requested index.
Return columns index_name and index_definition.
Include the five requested indexes, ordered alphabetically by index name.
The index definitions must show the verification schema used by the PostgreSQL catalog.

Schema

entities

Column	Type	Description
entity_idPK	INT	Entity identifier
external_code	VARCHAR(40)	Unique external lookup code
entity_type	VARCHAR(30)	Entity classification
attributes	JSONB	Flexible entity attributes

records

Column	Type	Description
record_idPK	INT	Record identifier
entity_id	INT	Referenced entity
status	VARCHAR(20)	Record status
created_at	TIMESTAMP	Record creation timestamp
payload	JSONB	Record payload

events

Column	Type	Description
event_idPK	INT	Event identifier
record_id	INT	Referenced record
event_type	VARCHAR(30)	Event classification
occurred_at	TIMESTAMP	Event timestamp
details	JSONB	Event details

Your question is Choose PostgreSQL Indexing Strategies. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem