Re: B-Tree support function number 3 (strxfrm() optimization)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Marti Raudsepp <marti(at)juffo(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, Greg Stark <stark(at)mit(dot)edu>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)
Date: 2014-12-03 14:39:18
Message-ID: CA+TgmoZ7ZQo8uGZbxO-cNH_bQGEhkzcCerYmv39Bmk_LO9XRsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 2, 2014 at 5:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter Geoghegan <pg(at)heroku(dot)com> writes:
>> On Tue, Dec 2, 2014 at 2:21 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>> Right, and what I'm saying is that maybe the "applicability" flag
>>> shouldn't be stored in the SortSupport object, but passed down as an
>>> argument.
>
>> But then how does that information get to any given sortsupport
>> routine? That's the place that really needs to know if abbreviation is
>> useful. In general, they're only passed a SortSupport object. Are you
>> suggesting revising the signature required of SortSupport routines to
>> add that extra flag as an additional argument?
>
> I think that is what he's suggesting, and I too am wondering why it's
> a good idea.

I find it somewhat confusing that we've got one flag which is only
used from the time the SortSupport object is created until the time
that it's fully initialized, and then a different way of indicating
whether we paid attention to that flag. I'm not totally sure what the
right solution to that problem is, but the current situation feels
like something of a wart.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message José Luis Tallón 2014-12-03 14:50:00 Re: Sequence Access Method WIP
Previous Message ktm@rice.edu 2014-12-03 14:01:38 Re: On partitioning