Re: Optimization in convert_string_datum? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Optimization in convert_string_datum?
Date
Msg-id 21504.1178141319@sss.pgh.pa.us
Whole thread Raw
In response to Optimization in convert_string_datum?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Optimization in convert_string_datum?
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> I'm reviewing the strxfrm patch, and while comparing that code to the
> code in varstr_cmp (which uses the same UTF8/UTF16 workaround but for
> strcoll instead), and I noticed that in varstr_cmp we have an
> optimization to use a stack based buffer instead of palloc if the string
> is short enough. Is convert_string_datum performance-critical enough to
> make it worthwhile to put a similar optimization there?

No, I don't believe so.  It should only get invoked a few times per
query at most, since only the planner uses it.

It would be far more useful to figure out a way to make that code
actually do something sane with multibyte encodings than to
micro-optimize what's there.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_index updates and SI invalidation
Next
From: Heikki Linnakangas
Date:
Subject: Re: Sequential scans