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

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)
Date: 2014-09-15 11:00:56
Message-ID: 5416C6E8.2090401@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/14/2014 11:34 PM, Peter Geoghegan wrote:
> On Sun, Sep 14, 2014 at 7:37 AM, Heikki Linnakangas
> <hlinnakangas(at)vmware(dot)com> wrote:
>> Both values vary in range 5.9 - 6.1 s, so it's fair to say that the useless
>> memcmp() is free with these parameters.
>>
>> Is this the worst case scenario?
>
> Other than pushing the differences much much later in the strings
> (which you surely thought of already), yes.

Please test the absolute worst case scenario you can think of. As I said
earlier, if you can demonstrate that the slowdown of that is acceptable,
we don't even need to discuss how likely or realistic the case is.

- Heikki

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-15 11:12:46 Re: [bug fix or improvement?] Correctly place DLLs for ECPG apps in bin folder
Previous Message Heikki Linnakangas 2014-09-15 10:57:27 Re: [REVIEW] Re: Compression of full-page-writes