HypoPG is a PostgreSQL extension that adds support for virtual indexes. A virtual index is an index that doesn’t really exist, and therefore doesn’t cost CPU, disk, or any resources to create. They are useful for knowing whether particular indexes can improve the performance of problematic queries, because you can tell if PostgreSQL will use those indexes without spending resources creating them.

Install

• Compatible with PostgreSQL 9.2 and higher
• Requires PostgreSQL header file
• Unzip the archive
• sudo make install
• In each required database: CREATE EXTENSION hypopg;