On Wed, 2024-08-14 at 01:31 +0200, Andreas Karlsson wrote:
> 0001-Remove-lc_collate_is_c.patch
> 
> Removes lc_collate_is_c().

This could use some performance testing, as the commit message says,
otherwise it looks good.

> 0002-Remove-lc_ctype_is_c.patch
> 
> Removes lc_ctype_is_c() and POSIX_COLLATION_OID which is no longer 
> necessary.

This overlaps a bit with what Peter already proposed here:

https://www.postgresql.org/message-id/4f562d84-87f4-44dc-8946-01d6c437936f%40eisentraut.org

right?

> 0003-Remove-dubious-check-against-default-locale.patch
> 
> This patch removes a check against DEFAULT_COLLATION_OID which I
> thought 
> looked really dubious. Shouldn't this just be a simple check for if
> the 
> locale is deterministic? Since we know we have a valid locale that 
> should be enough, right?

Looks good to me. The code was correct in the sense that the default
collation is always deterministic, but (a) Peter is working on non-
deterministic default collations; and (b) it was a redundant check.

> 0004-Do-not-check-both-for-collate_is_c-and-deterministic.patch
> 
> It is redundant to check both for "collation_is_c && deterministic",
> right?

+1.

> 0005-Remove-pg_collate_deterministic-and-check-field-dire.patch
> 
> Since after my patches we look a lot directly at the collation_is_c
> and 
> ctype_is_c fields I think the thin wrapper around the deterministic 
> field makes it seem like there is more to it so I suggest that we
> should 
> just remove it.

+1. When I added that, there was also a NULL check, but that was
removed so we might as well just read the field.

> 0006-Slightly-refactor-varstr_sortsupport-to-improve-read.patch
> 
> Small refactor to make a hard to read function a bit easier to read.

Looks good to me.

Regards,
        Jeff Davis



Reply via email to