September 7th, 2015 by depesz | Tags: , , , , , | 5 comments »

There exists an extension to PostgreSQL, which lets you use hypothetical indexes. What are there? That's simple - these are indexes that don't really exist. So what good are they? Let's see.