Re: Tid scan improvements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Tid scan improvements
Date
Msg-id 8469.1545344467@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tid scan improvements  (Edmund Horner <ejrh00@gmail.com>)
Responses Re: Tid scan improvements  (Andres Freund <andres@anarazel.de>)
Re: Tid scan improvements  (Edmund Horner <ejrh00@gmail.com>)
List pgsql-hackers
Edmund Horner <ejrh00@gmail.com> writes:
> [ tid scan patches ]

I'm having a hard time wrapping my mind around why you'd bother with
backwards TID scans.  The amount of code needed versus the amount of
usefulness seems like a pretty bad cost/benefit ratio, IMO.  I can
see that there might be value in knowing that a regular scan has
"ORDER BY ctid ASC" pathkeys (mainly, that it might let us mergejoin
on TID without an explicit sort).  It does not, however, follow that
there's any additional value in supporting the DESC case.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: monitoring CREATE INDEX [CONCURRENTLY]
Next
From: Andres Freund
Date:
Subject: Re: Tid scan improvements