> This is the kind of thing that is "hard and tedious" for only about five minutes of LLM query or web search time

not even! if you don't need to go super deep with tablespace configs or advanced replication right away, pgtune will get you to a pretty good spot in the time it takes to fill out a form.

https://pgtune.leopard.in.ua/

https://github.com/le0pard/pgtune

Glad you mentioned these resources. I was soft-pedaling it to avoid the "Look, a gatekeeper!" brigade.