Add an index on some DB backends?

[ldidry]

Hello,

At Framasoft, we have a ±100GiB PostgreSQL database for our Etherpad instance with MyPads plugin (more than 100,000 pads). MyPads uses the store table of Etherpad to store data. I needed to search some of those data (say SELECT * FROM STORE WHERE key LIKE 'mypads:user:%';) and it was horribly slow. After some tests, I added an index on the key column and the time dropped from more than 2 minutes to less than 100ms.

I added this index:

CREATE INDEX pattern_idx ON store (key varchar_pattern_ops);

Since Etherpad do some queries similar to the one I used, I think Etherpad should benefit of such index.

What do you think? Should it go in Etherpad do you think it should go in UeberDB?

[ghost]

Somehow related: #1957. Anyway, I think this issue belongs to https://github.com/Pita/ueberDB/ :-)

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.