From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
---|---|
To: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, amul sul <sulamul(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, David Steele <david(at)pgmasters(dot)net>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [POC] hash partitioning |
Date: | 2017-05-16 13:30:21 |
Message-ID: | 0b4de30f-7297-d5de-b8c2-03620fd0ae43@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 5/16/17 03:19, Ashutosh Bapat wrote:
> On Tue, May 16, 2017 at 10:03 AM, amul sul <sulamul(at)gmail(dot)com> wrote:
>> On Mon, May 15, 2017 at 9:13 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>>>> Collation is only relevant for ordering, not equality.
>
> While earlier, I thought the same, I am wondering whether this is
> true. Don't different collations deem different strings equal e.g one
> collation may deem 'aa' and 'AA' as same but other may not. Or is that
> encoding problem being discussed in hash functions thread?
The collations we currently support don't do that, unless someone made a
custom one. However, we might want to support that in the future.
Also, text/varchar comparisons always use strcmp() as a tie-breaker.
Again, this might be something to review at some point.
But you currently have the citext type that would indeed consider 'aa'
and 'AA' equal. But citext also has a hash function in the hash
operator class that handles that. So you could look into using that
approach.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Ildus Kurbangaliev | 2017-05-16 14:26:00 | Re: Bug in ExecModifyTable function and trigger issues for foreign tables |
Previous Message | Amit Kapila | 2017-05-16 13:25:30 | Re: bumping HASH_VERSION to 3 |