Postgres has a ton of parameters that can greatly affect performance. I've used https://pgtune.leopard.in.ua/ https://pgtune.leopard.in.ua/ to help w/ that. In

Postgres has a ton of parameters that can greatly affect performance. I've used https://pgtune.leopard.in.ua/ https://pgtune.leopard.in.ua/ to help w/ that. In terms of schemas, where you put your indexes matters a TON. Indexes make reads faster and writes slower (to oversimplify). Figuring out where to break out a separate table vs keep everything in one table is also a common issue.