Re: B-Tree support function number 3 (strxfrm() optimization)
От | Robert Haas |
---|---|
Тема | Re: B-Tree support function number 3 (strxfrm() optimization) |
Дата | |
Msg-id | CA+Tgmoa2FMWJ=2YNJ4mBhOk__VmAz5T_L1ZtFuiSNfsGA=sOFA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: B-Tree support function number 3 (strxfrm() optimization) (Peter Geoghegan <pg@heroku.com>) |
Ответы |
Re: B-Tree support function number 3 (strxfrm() optimization)
|
Список | pgsql-hackers |
On Mon, Sep 15, 2014 at 7:21 PM, Peter Geoghegan <pg@heroku.com> wrote: > On Mon, Sep 15, 2014 at 11:25 AM, Peter Geoghegan <pg@heroku.com> wrote: >> OK, I'll draft a patch for that today, including similar alterations >> to varstr_cmp() for the benefit of Windows and so on. > > I attach a much simpler patch, that only adds an opportunistic > "memcmp() == 0" before a possible strcoll(). Both > bttextfastcmp_locale() and varstr_cmp() have the optimization added, > since there is no point in leaving anyone out for this part. Even though our testing seems to indicate that the memcmp() is basically free, I think it would be good to make the effort to avoid doing memcmp() and then strcoll() and then strncmp(). Seems like it shouldn't be too hard. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: