Re: More ideas for speeding up sorting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: More ideas for speeding up sorting
Date: 2016-09-09 21:15:31
Message-ID: 18081.1473455731@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Geoghegan <pg(at)heroku(dot)com> writes:
> I know that in practice, even virtual address space is significantly
> less than 64-bits on x86_64, so I think that there should be several
> bits there for the taking, even if the addresses are not aligned
> (although, they are). However, I have no idea if there is any
> precedent for this general idea at all, and would feel better about it
> if there was. I guess we don't have to make it any more complicated
> than your argument about alignment.

There's a very long history of code stealing bits out of pointers, and
all of it is bad and unportable in the long run :-(. Let's not go there.
I thought the idea of getting rid of isnull by physically segregating the
null items sounded good though.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2016-09-09 21:25:46 Re: Floating point comparison inconsistencies of the geometric types
Previous Message Tom Lane 2016-09-09 21:08:19 Re: Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC]