Horton

Re: Tid scan improvements

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: David Rowley <dgrowleyml@gmail.com>, Edmund Horner <ejrh00@gmail.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-06-07T19:38:20Z
Lists: pgsql-hackers 
On 07.06.21 13:50, David Rowley wrote:
> On Mon, 7 Jun 2021 at 23:46, Edmund Horner <ejrh00@gmail.com> wrote:
>>
>> 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.
> 
> Yeah. That was forgotten.  Patch also looks fine to me.  Do you want
> to push it, Peter?

done

Commits

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

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