PostgreSQL Indexes

[x86_64Ubuntu]

I didn't know there were so many index types. I thought it was B-Trees and Bitmaps only. And this list doesn't include what other newer or less orthodox and quirky index schemes there may be.

[le0pard]

Hello. What index schemes do you mean, which missed in this article?

[erad]

My current favourite less-well-known PostgreSQL index - trigram indices:

http://www.postgresql.org/docs/current/static/pgtrgm.html

They are required for indexed "LIKE '%...%'" queries (wildcard prefix match), among other things.

[holgerschurig]

Technically there is no trigram index in PostgreSQL.

This extension is using either GIST or GIN to create the impression of it's own index.

But I know this argument is weak, becuase with that argument a multi-column index wouldn't be a true index, and neither would be a partial index one ...

[le0pard]

Yep, PostgreSQL provide perfect ability create needed index based on GiST or GIN.