pgsql: Speed up CREATE INDEX CONCURRENTLY's TID sort.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Speed up CREATE INDEX CONCURRENTLY's TID sort.
Date: 2015-12-16 20:28:33
Message-ID: E1a9Igb-0007qP-Fg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Speed up CREATE INDEX CONCURRENTLY's TID sort.

Encode TIDs as 64-bit integers to speed up comparisons. This seems to
speed things up on all platforms, but is even more beneficial when
8-byte integers are passed by value.

Peter Geoghegan. Design suggestions and review by Tom Lane. Review
also by Simon Riggs and by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b648b70342fbe712383e8cd76dc8f7feaba9aaa3

Modified Files
--------------
src/backend/catalog/index.c | 71 ++++++++++++++++++++++++++++++++++++++++---
1 file changed, 67 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2015-12-16 21:59:53 pgsql: Cope with Readline's failure to track SIGWINCH events outside of
Previous Message Robert Haas 2015-12-16 12:47:11 pgsql: Mark CHECK constraints declared NOT VALID valid if created with