On Mon, Sep 15, 2014 at 8:28 AM, Alexander Korotkov <aekorot...@gmail.com> wrote: > some GIN opclasses uses collation-aware comparisons while they don't need to > do especially collation-aware comparison. Examples are text[] and hstore > opclasses. Depending on collation this may make them a much slower.
I'm glad that I saw how pointless this was with the jsonb GIN default opclass during development. > Rename such opclasses and make them not default. > Create new default opclasses with bitwise comparison functions. > Write recommendation to re-create indexes with default opclasses into > documentation. I certainly think this should be fixed if at all possible, but I'm not sure about this plan. Can we really rename an opclass without consequence, including having that respected across pg_upgrade? -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
