Furkan
How do I migrate a table to PostgreSQL partitioning with zero downtime?
Stand up monthly RANGE declarative partitioning on `created_at`, backfill history in batches while the app writes, then swap names in a single transaction.
All questions
Tag
#Database
Database choice, schema, query and operational decisions that outlive the engine. (Page 2/2)
18 answered questions carry this tag.
Sinan
What rules should I follow to prevent database deadlocks?
Acquire locks in one global order such as ascending PK, keep transactions short, target `FOR UPDATE` at the fewest rows, and retry the rest with backoff.
Levent
Disaster recovery: how do I design an active-passive scenario around RTO and RPO?
RPO 5min buys continuous cross-region replication and PITR, RTO 30min an IaC-provisioned warm standby behind Route 53 failover, rehearsed on a game-day.
Volkan
How do I prevent PostgreSQL split-brain with quorum and consensus?
Don't hand-roll failover: put promotion behind a Patroni + etcd quorum, and let a primary cut off from the majority demote itself by fencing.
Efe
How do I make search-as-you-type fast with edge n-grams in Elasticsearch?
Drop wildcard for autocomplete; build the prefixes at index time with edge_ngram and keep a standard search analyzer so a keystroke is a plain term lookup.
Pelin
Which PgBouncer pooling mode should I pick — Session, Transaction, or Statement?
Pick Transaction mode for a web fleet; the price is protocol-level prepared statements, so disable them in the app or turn on PgBouncer 1.21+ support.
Doğa
How do I choose the right composite index column order in PostgreSQL?
Build one (user_id, status, created_at DESC) index with equality columns first and the sort column last, then drop the single-column indexes it now covers.
Berk
Multi-tenant SaaS database isolation: separate DB, schema, or tenant_id?
Database-per-tenant does not scale operationally at 10k; keep tenant_id on every table and bury isolation in Postgres Row-Level Security instead.