Hello, I attempted to create the indexes adapting the commands to Postgresql and I had success for almost all of them.
-- xwikilargestrings
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwl_value ON xwikilargestrings (xwl_value);
-- xwikidoc
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwd_parent ON xwikidoc (xwd_parent);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwd_class_xml ON xwikidoc (xwd_class_xml);
-- xwikistatsdoc
CREATE INDEX CONCURRENTLY IF NOT EXISTS xws_number ON xwikistatsdoc (xws_number);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xws_classname ON xwikistatsdoc (xws_classname);
-- xwikistatsreferer
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwr_number ON xwikistatsreferer (xwr_number);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwr_classname ON xwikistatsreferer (xwr_classname);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwr_referer ON xwikistatsreferer (xwr_referer);
-- xwikistatsvisit
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwv_user_agent ON xwikistatsvisit (xwv_user_agent);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwv_cookie ON xwikistatsvisit (xwv_cookie);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwv_classname ON xwikistatsvisit (xwv_classname);
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwv_number ON xwikistatsvisit (xwv_number);
-- activitystream_events
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_page_date ON activitystream_events (ase_page, ase_date);
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_param1 ON activitystream_events (ase_param1);
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_param2 ON activitystream_events (ase_param2);
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_param3 ON activitystream_events (ase_param3);
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_param4 ON activitystream_events (ase_param4);
CREATE INDEX CONCURRENTLY IF NOT EXISTS ase_param5 ON activitystream_events (ase_param5);
-- xwikiattrecyclebin
CREATE INDEX CONCURRENTLY IF NOT EXISTS xda_docid1 ON xwikiattrecyclebin (xda_docid);
My issue right now is with the first one:
CREATE INDEX CONCURRENTLY IF NOT EXISTS xwl_value ON xwikilargestrings (xwl_value);
It is returning the following error:
ERROR: index row requires 20944 bytes, maximum size is 8191
SQL state: 54000
Is there an alternative way or something to workaround this limitation?
I don’t want to make a mess lol.
Thank you 