I have a varying(200) text column that I need to be able to do lookups
on very fast (WHERE col = 'foo') - The data in this table will pretty
much never change (when it does I have to restart the entire server,
so updates of any sort are extremely rare). I estimate the table will
hold around 5,000 rows, never any more.
Am I better off using a btree index or should I use GiN? From what
I've read, GiN is extremely fast, but very slow for updates. However,
it was unclear to me if they're only fast when doing fulltext
searches, or if they're just fast period.
Thanks!
Mike