text_pattern_ops index on public.blocks.key

[i-norden]

Our Postgres servers are very likely not configured with the "C" locale (but rather "UTF-8'), in which case the default operator class for the btree index on a TEXT column is not optimized for pattern matching expressions (e.g. LIKEs, prefix scans).

E.g. CREATE INDEX IF NOT EXISTS blocks_key_text_pattern_ops_idx ON public.blocks (key text_pattern_ops)

We may want to leave the existing btree index on key (from its UNIQUE NOT NULL constraint), as the default operator class index is optimized for ordinary <, <=, >, or >= comparisons.