Rusty Conover <rcono...@infogears.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance