deavid wrote: > There are several use cases where I see useful an index, but adding it will > slow too much inserts and updates.
Maybe try a BRIN index. You can't use them for text search currently, or many other cases for that matter, but there are enough interesting cases in which they are useful that perhaps you don't need anything extra. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers