Current Release

This documentation covers the current version of Fedora. Looking for another version? See all documentation.

Fedora utilizes primary key indexes on its tables. These indexes do not work efficiently for some types of queries ( LIKE ) if your Postgres database's LC_COLLATE  setting is anything other than C  (for example en_US.utf8 ).

Fedora accounts for this by creating a secondary index ( resources_idx2 ) to allow it to continue working efficiently.

You can avoid the creation of a second index by configuring your Postgres server with a locale of C. More details on Postgres's LOCALE support can be found in Section 23.1 of the Postgres manual.

  • No labels