Re: What type of index should I use?

Mike Christensen <mike@kitchenpc.com> writes:

> I have a varying(200) text column that I need to be able to do lookups
> on very fast (WHERE col = 'foo')

Btree is what to use here. GIN covers cases where you index arrays.

>   I estimate the table will hold around 5,000 rows, never any more.

It could be that you're better off without any index, depending on the
size of rows you put in there, and the overall memory usage patterns you
have.

Regards,
--
dim