hmm indeed it’s weird that we don’t have a page for postgresql at https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Performances/Database%20Administration/#HIndexes
I thought we didn’t have one because it was not needed for postgresql as all indexes could be created automatically for it. But apparently I’m wrong since I can see entries missing “index” attributes on xwiki-platform/xwiki-platform-core/xwiki-platform-oldcore/src/main/resources/xwiki.postgresql.hbm.xml at 93e5825fa7cd91abdbd1b4a65d7672e137299c5b · xwiki/xwiki-platform · GitHub
There’s also no mention of indexes on https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationPostgreSQL/
@tmortagne any idea why we’re missing this? do you remember anything related to this?