The thing with PostgreSQL is that it may decide that it can find the result faster without the index, than it can with the index. This is sometimes due to the f

The thing with PostgreSQL is that it may decide that it can find the result faster without the index, than it can with the index. This is sometimes due to the fact our development machines have alot of memory and its easier for PostgreSQL to store the table data in memory and not bother with the index. This is a problem when trying to test an index on a small dataset. It may look like the index is not useful, when infact it will be useful.