Re: PostgreSQL 10: Call for Quotes
Robert Haas <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.advocacy |
|---|---|
| Message-ID | <CA+TgmoZgMUBcNou3RNAuGuAERTuZwNtVwdoRafvenh8zhxdOOw@mail.gmail.com> |
On Fri, Sep 1, 2017 at 1:35 AM, Simon Riggs <[email protected]> wrote: > Are we safe to draw attention to these indexes, for a particular use > case? Can we get a clear statement of what that is? If we can, I would > incline towards adding them to the major items list. I think it's cases where the keys are very wide, only equality lookups are needed, and the data isn't changing a ton. Write performance for hash indexes is still not fantastic, although I believe that, due to the single-page vacuuming logic in particular, it's a lot better than formerly. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-advocacy mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-advocacy