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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
