Endlessly running Postgres processes & bad performance after Reinstall/restore

[RGJ (Richard - Communiteq)]

@pfaffman

I’m not expert at huge databases, but I’d make the buffers two or three times that.

Postgres recommends never setting shared_buffers over 40% of the internal memory?

That said,

@helmi

our database is quite huge - we’re at around 150gb after the restore and after index creation

@helmi

32GB

Your server might be underdimensioned.