It took me years before I started tuning the memory-related configuration of postgres for workload, schema and data, in any way. It "just works" for the first ten thousand concurrent users.

▲

cluckindan 11 hours ago | parent | next [-]

Well, most people working on a car don’t have a car lift: it only makes sense when you need to safely work on a large volume of cars. If you only work on one or two, a jack and a pile of wood works just fine.

	▲	nkmnz 9 hours ago \| parent [-]
		Please don't move the goal post. Writing `no database ”just works” without (...)` is gatekeeping behavior, creating an image of complexity that for most use cases - especially for those starting out - just doesn't exist.

▲

kamma4434 11 hours ago | parent | prev | next [-]

Modern JVMs are pretty effective in most scenarios right out of the box.

▲

_joel 10 hours ago | parent | prev [-]

I just tend to use https://github.com/le0pard/pgtune