How to Optimize Search Queries on a Large PostgreSQL Table without Compound Indexes?
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id
, tenant_id
, name
, company
, location
, and description
.