Re: Is it possible to have a "fast-write" Index?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: deavid <deavidsedice(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is it possible to have a "fast-write" Index?
Date: 2015-06-05 18:11:34
Message-ID: 20150605181134.GT133018@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-06-05 18:26:57 Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Previous Message Claudio Freire 2015-06-05 18:09:22 Re: Is it possible to have a "fast-write" Index?