indexing performances

[Sebastien Binet]

hi there,

I am using Perkeep since a couple of weeks, with a couple of instances
to handle the "multi-user" use case.

on one instance, I have a 180Gb blob/packed store with a ~700Mb sqlite index.
at times, queries feel a bit sluggish.

I understand modernc.org/sqlite is very convenient (being pure-Go and
all).
but, if I am willing to bite that bullet, would switching to, say,
postgres or mariadb, buy me anything, performance-wise?

or leveldb?

cheers,
-s

[Sebastien Binet]

after a couple of days of testing, I can safely say using postgres feels
like a performance boon.
(not a scientific data point)

>
> or leveldb?

I have also switched ot leveldb for the thumbmetadata: feels like a
performance boon as well.
(not a scientific data point either).

cheers,
-s