Thread: Improve database performance

Improve database performance

From
ourdiaspora
Date:
Mail list readers,

Using Postgresql as the database for a Hubzilla server installed on a VPS system, the database has declined recently,
suchthat the postgresql server has to be restarted. That was successful (someone suggested the failure was due to an
"out-of-memory"occurence). 

Postgresql is being used with Hubzilla (https://zotlabs.org/help/en/about/about#What_is_Hubzilla_) and installed onto a
Debiansystem. 

Any advice please about how to improve database performance, investigate further the configuration, etc.?