Greg Maxwell <gmaxwell(at)martin(dot)fl(dot)us> writes:
> On performing queries such as select * from table where name ~ '^NAME.*';
> the database fails to use the available Btree index where available, even
> when the database is told not to use the SEQ_SCAN optimization.
> PGsql was initlized and is started with the scripts in the RPM, so
> LC_ALL=C is set. PSQL is also run with LC_ALL=C.
Are you *certain* the DB was initialized in locale C? Try running
contrib/pg_controldata to be sure.
regards, tom lane