Improve database performance - Mailing list pgsql-novice

From ourdiaspora
Subject Improve database performance
Date
Msg-id XI67FGG4X-d7UhpiIWywL8dK74xDCC2sFxgHdlpqSVSmfimdpDOajsTYvXPrZENiDffD5Ef5ap-QxSZtL7eul4BL9Y0qNE8ZJRK9njzD3Jk=@protonmail.com
Whole thread Raw
List pgsql-novice
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.?





pgsql-novice by date:

Previous
From: ourdiaspora
Date:
Subject: mail-archive RSS feed
Next
From: "Greg Rychlewski (LCL)"
Date:
Subject: NOTIFY