The $10 VPS that serves your web app can run Postgres just fine. If it can’t? Fire up another $10 VPS. Learn how to tune your configs and network settings and query/cache efficiently.

▲

edoceo 15 hours ago | parent [-]

Any pointers to network configuration to tune? Some TCP stuff? How much does it matter on that VPS network?

	▲	Lukas_Skywalker 13 hours ago \| parent \| next [-]
		This is a pretty good resource for some basic tuning (mostly buffer sizes and connection count): https://pgtune.leopard.in.ua/
	▲	allthetime 14 hours ago \| parent \| prev \| next [-]
		Yeah mostly just keepalives and timeouts, increasing kernel maximums for connections, using Unix sockets directly instead of tcp, using pgbouncer, etc. as always, depends on use case and monitoring and measuring to determine your needs is good.
	▲	chasd00 14 hours ago \| parent \| prev [-]
		man, i wouldn't worry about tuning something like TCP until you can reliably prove TCP is the bottle neck in performance. That day will likely never come for most companies.