Horton

Re: Joins on TID

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@lists.postgresql.org
Date: 2018-12-22T04:31:46Z
Lists: pgsql-hackers

Attachments

BTW, if we're to start taking joins on TID seriously, we should also
add the missing hash opclass for TID, so that you can do hash joins
when dealing with a lot of rows.

(In principle this also enables things like hash aggregation, though
I'm not very clear on a use-case for grouping by TID.)

			regards, tom lane

Commits

  1. Add a hash opclass for type "tid".

  2. Support parameterized TidPaths.