INTRODUCTION TO POSTGRESQL INDEXES

Summary from the TLDR Dev newsletter

PostgreSQL indexes are database objects that speed up data access by allowing the system to read less from disk, mapping key values to physical row locations. While these provide speed benefits for queries, they introduce costs such as increased disk space, overhead on write operations, longer query planning times, and higher memory usage.