I am currently running a linux server on my Pi 4 (8GB RAM) which is running postgresql for a server that requires it. However, it seems it is occasionally running a little bit slow. Are there any tips to help speed up the database without crashing my Pi 4?
I’m going to be following this thread as well.
With MySQL there’s actionable performance tips that are so easy to find online and in official documentation.
I don’t have that much experience with postgresql, albeit considered the better DB solution of the 2.
So it would be nice if we end up here with a nice actionable list of do’s and don’s.
Perhaps you could make a blog post out of this
Can certainly link to it. Guest posts are also always welcome.
But I don’t have enough experience or working knowledge of postgresql to make a post about it or to guide anyone.
This is why the forums are cool because I’m learning and filling gaps, and also we all get to interact and expand beyond my very static articles.
Edit: Curiously I searched the forum for PostgreSQL and only found this : Options for Postgresql monitoring + trend graphs