Hypothetical Indexes support for PostgreSQL



HypoPG is an extension adding support for hypothetical indexes in PostgreSQL.

It can be used alone, even if some other tool like PoWA can use it.


An example of HypoPG usage is available on the official PoWA demo, for instance with the "Optimize this database!" feature on the tpc database. Check out our live demo and test it by yourself.

Please let us know what you think of it and how we can improve this tools !

server : http://demo-powa.dalibo.com/

login : powa

pass : demo


HypoPG is available under the PostgreSQL license. You allowed to download, use and modify this software as long as you maintain our copyright notice.

The main code is a PostgreSQL extension written in C.


The HypoPG documentation is available online.

Contact Us

Report an Issue

Please use the bug tracking system in the github project page: https://github.com/dalibo/hypopg/issues


We're looking for comments and contributions to improve this tools. powa@dalibo.com and let us know how we can make it better.


You can find help, news and security alerts on the powa-users mailing list. You can also join directly the developer team on the #powa channel of the freenode IRC network.

Commercial support

DALIBO, as the sponsor of the project, can provide enterprise grade support services for both PostgreSQL, HypoPG and POWA. See http://www.dalibo.com for more details.

For a complete list of commercial support near of your place take a look at the PostgreSQL Professional Services page, they all do great job and most of them can help you.