Jon Anderson <jonanderson.mn@gmail.com> writes:
> Any hints on what to do to make PostgreSQL use the index?

You might want to reduce random_page_cost a little.

Keep in mind that your test case is small enough to fit in RAM and is
probably not reflective of what will happen with larger tables.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org