I'm a member of Framasoft, an non-profit association that proposes, among other services, a free instance of TTRSS.
We were running out of space on our server and I saw that the index for pgsql full-text search (ttrss_entries_tsvector_combined_idx) is taking a lot of place (±57GB). As I activated the sphinx search plugin, would it be safe to drop or truncate this index?
Other question : would it be ok to add an option in config.php to disable full-text search related code in include/rssfuncs.php and include/functions2.php? For now, this code is in a
Code: Select all
if (DB_TYPE == "pgsql") {
Code: Select all
if (DB_TYPE == "pgsql" && USE_PG_FULL_TEXT_SEARCH ) {
I only looked for "tsvector" in TTRSS code, but if there is other full-text search related code I didn't saw, could you please say me what I have to look for?
Thank you.