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