Yves Martin <yma(at)elca(dot)ch> writes:
> base=# select * from persistent_config where key like '/%';
> key | type | value
> -----+------+-------
> (0 rows)
What LOCALE are you running in? There are some known problems with
LIKE index optimization in some non-ASCII locales. If you drop
the index on persistent_config.key, does the problem disappear?
regards, tom lane