Rusty Conover <rconover@xxxxxxxxxxxxx> writes: > Since 100% of my queries are for retrieval, I should use GIN but it > never appears to be used unlike how GIST indexes are: You haven't shown us either the table or the index declaration, so it's a bit tough to comment on that. It's worth noting though that your GIST example appears to rely on a nonstandard operator class. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
