Re: Per-column collation, the finale - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Per-column collation, the finale
Date
Msg-id 20110203233624.GA18572@tornado.gateway.2wire.net
Whole thread Raw
In response to Re: Per-column collation, the finale  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Per-column collation, the finale
Re: Per-column collation, the finale
List pgsql-hackers
On Thu, Feb 03, 2011 at 05:53:28PM +0200, Peter Eisentraut wrote:
> On tor, 2011-02-03 at 00:10 -0500, Noah Misch wrote:
> > > This is good stuff.  I'll send you a new patch in a day or three for
> > > perhaps another round of performance tests.  Some of the other
> > issues
> > > above can perhaps be postponed for follow-up patches.
> >
> > I agree -- if the performance-when-unused gets solid, none of my other
> > comments ought to hold things up.
>
> Here is a new patch.
>
> The main change is in varstr_cmp(), avoiding the calls to
> pg_newlocale_from_collation() when the default locale is used.  This
> accounts for the performance regression in my tests.  It also addresses
> some of your refactoring ideas.

Looks good and tests well.  I've attached the same benchmark script with updated
timings, and I've marked the patch Ready for Committer.

nm

Attachment

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ALTER EXTENSION UPGRADE, v3
Next
From: Andrew Dunstan
Date:
Subject: exposing COPY API