PostgreSQL Database

6.

Indexes and Performance

6.1.

Understanding Query Plans

6.1.1.

EXPLAIN Command

6.1.2.

EXPLAIN ANALYZE

6.1.3.

Reading Execution Plans

6.1.4.

6.1.4.1.

Sequential Scan

6.1.4.2.

6.1.4.3.

Bitmap Index Scan

6.1.4.4.

6.1.4.5.

6.1.4.6.

6.2.

Indexing Concepts

6.2.1.

How Indexes Work

6.2.2.

6.2.3.

Index Maintenance

6.2.4.

Trade-offs of Indexing

6.2.4.1.

Read Performance

6.2.4.2.

Write Performance

6.2.4.3.

Disk Space Usage

6.3.

6.3.1.

6.3.2.

6.3.3.

6.3.4.

SP-GiST Indexes

6.3.5.

6.3.6.

6.4.

Advanced Indexing Techniques

6.4.1.

Partial Indexes

6.4.2.

Expression Indexes

6.4.3.

Covering Indexes

6.4.4.

Multi-column Indexes

6.4.5.

6.5.

Index Maintenance

6.5.1.

REINDEX Command

6.5.2.

Monitoring Index Usage

6.5.3.

Dropping Indexes

6.5.4.

Rebuilding Indexes

6.5.5.

6.5.6.

Previous

5. Advanced Querying

Go to top

Next

7. Transactions and Concurrency Control