Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Explicit deterministic COLLATE fails with pattern matching operations on column with non-deterministic collation
Date
Msg-id 7943.1590698880@sss.pgh.pa.us
Whole thread Raw
In response to Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation  (James Lucas <jlucasdba@gmail.com>)
List pgsql-bugs
James Lucas <jlucasdba@gmail.com> writes:
> So that is something to be aware of - the collation defined on the
> column can impact stats values, which could in turn impact plans
> chosen for queries that use alternative collations.

Yeah.  At some point we might try to collect stats with respect to
multiple collations, but that's a long way off probably.

(I have suggested that CREATE STATISTICS could be extended to
control this type of thing, but I don't think anyone's worked
on making it happen.)

            regards, tom lane



pgsql-bugs by date:

Previous
From: James Lucas
Date:
Subject: Re: Explicit deterministic COLLATE fails with pattern matchingoperations on column with non-deterministic collation
Next
From: PG Bug reporting form
Date:
Subject: BUG #16469: High unicode character mangled on write and read with ODBC driver