4 ms·
The official manual + distro docs are the best source afaik if you need to run in a VM or VPS. It's not too hard if your needs are simple (i.e. you don't have
by dimitar 5y ago
The official manual + distro docs are the best source afaik if you need to run in a VM or VPS.
It's not too hard if your needs are simple (i.e. you don't have any complicated DR or replication requirements).
First and most importantly: Setup a simple and reliable way to backup and restore.
Make sure you log long running queries.
Finally you can do some tuning:
https://pgtune.leopard.in.ua/ https://pgtune.leopard.in.ua/