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.
