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