Retroactive freeze break request: Add indexes for ipsilon

[Patrick Uiterwijk]

Hi,

So it turned out that the slowness of Ipsilon was caused by the lack of keys on the
database,
so it got slower over time, as more entries got added.

I just ran the following queries to create new indexes on production, could I get any +1s
retroactive?

-----------------------------------------------------
ALTER TABLE association ADD PRIMARY KEY (uuid,name);
CREATE INDEX ON association (uuid);

ALTER TABLE dbinfo ADD PRIMARY KEY (name, option);
CREATE INDEX ON dbinfo (name);

ALTER TABLE openid_data ADD PRIMARY KEY (name, option);
CREATE INDEX ON openid_data (name);

ALTER TABLE sessions ADD PRIMARY KEY (id);
CREATE INDEX ON sessions (expiration_time);

ALTER TABLE transactions ADD PRIMARY KEY (uuid, name);
CREATE INDEX ON transactions (uuid);

ALTER TABLE users ADD PRIMARY KEY (name, option);
CREATE INDEX ON users (name);
-----------------------------------------------------


With kind regards,
Patrick Uiterwijk
Fedora Infra