Re: BRIN indexes and ORDER BY - Mailing list pgsql-general

From Darren Lafreniere
Subject Re: BRIN indexes and ORDER BY
Date
Msg-id CABoC1=6OPihNCyCvPgz_iGcGoC9tYEeC7_CSXNhzisovzxAtOg@mail.gmail.com
Whole thread Raw
In response to Re: BRIN indexes and ORDER BY  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Ahh, yes. I misread that. Thank you for the clarification.

On Wed, Oct 5, 2016 at 2:27 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Darren Lafreniere wrote:

> "In addition to simply finding the rows to be returned by a query, an index
> may be able to deliver them in a specific sorted order. This allows a
> query's ORDER BY specification to be honored without a separate sorting
> step. Of the index types currently supported by PostgreSQL, only B-tree can
> produce sorted output — the other index types return matching rows in an
> unspecified, implementation-dependent order."
>
> We found a pgsql-hackers thread from about a year ago about optimizing
> ORDER BY for BRIN indexes. Tom Lane suggested that he was working on it:
> https://www.postgresql.org/message-id/11881.1443393360%40sss.pgh.pa.us

Tom said he was working on some infrastructure planner changes
("upper-planner path-ification"), not that he was working on improving
usage of BRIN indexes.  As far as I know, nobody has worked on that.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BRIN indexes and ORDER BY
Next
From: Magnus Hagander
Date:
Subject: Re: Unexpected trouble from pg_basebackup