Query Optimization When No Indexes Exist

Created: Last edited:
https://hdombrovskaya.wordpress.com/2026/08/25/how-to-optimize-when-you-cant-do-anything/

A query optimization guide for PostgreSQL. Focuses on selective indexes and parallel execution. Addresses a real-world performance issue in a large monolithic table.

Image: https://1.gravatar.com/avatar/a85191b2748d06ccc400cb852c8e29c8d3d554bda4ef033b93d1589d9f7be6c5?s=96&d=identicon&r=G

#postgresql #query #optimization #database

Views: 3

Categories: Articles & Guides [c4], Projects & Resources [c5]

Manage / Login

The Bitcoin-Powered Internet Bulletin Board