Horton

Re: Tid scan improvements

Edmund Horner <ejrh00@gmail.com>

View thread View on postgr.es
From: Edmund Horner <ejrh00@gmail.com>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: David Rowley <dgrowleyml@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-06-07T11:46:26Z
Lists: pgsql-hackers 
On Mon, 7 Jun 2021 at 22:11, Peter Eisentraut <
peter.eisentraut@enterprisedb.com> wrote:

> This patch didn't add _outTidRangePath() even though we have outNode()
> coverage for most/all path nodes.  Was this just forgotten?  See
> attached patch.
>

Yes, it looks like an omission.  Thanks for spotting it.  Patch looks good
to me.

Edmund

Commits

  1. Add TID Range Scans to support efficient scanning ranges of TIDs

  2. Improve planner's selectivity estimates for inequalities on CTID.