Re: Tid scan improvements
Edmund Horner <ejrh00@gmail.com>
From: Edmund Horner <ejrh00@gmail.com>
To: alvherre@2ndquadrant.com
Cc: David Rowley <david.rowley@2ndquadrant.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2018-11-07T22:31:05Z
Lists: pgsql-hackers
Attachments
- remove-obsolete-ExecStoreTuple-notes.patch (application/octet-stream) patch
On Tue, 6 Nov 2018 at 16:52, Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > On 2018-Nov-06, David Rowley wrote: > > 14. we pass 'false' to what? > > > > + * save the tuple and the buffer returned to us by the access methods in > > + * our scan tuple slot and return the slot. Note: we pass 'false' because > > + * tuples returned by heap_getnext() are pointers onto disk pages and were > > + * not created with palloc() and so should not be pfree()'d. Note also > > + * that ExecStoreHeapTuple will increment the refcount of the buffer; the > > + * refcount will not be dropped until the tuple table slot is cleared. > > */ > > Seems a mistake stemming from 29c94e03c7d0 ... Yep -- I copied that bit from nodeSeqscan.c. Some of the notes were removed in that change, but nodeSeqscan.c and nodeIndexscan.c still have them. I made a little patch to remove them.
Commits
-
Add TID Range Scans to support efficient scanning ranges of TIDs
- bb437f995d47 14.0 landed
-
Improve planner's selectivity estimates for inequalities on CTID.
- f7111f72d2fd 12.0 landed