Server roles in a Postgres cluster
- Primary → Server that can modify data.
- Standby → Server that replicates the data changes on the primary server.
- Warm standby → Standby server that doesn't accept connections until it's promoted to a primary server.
- Hot standby → Standby server that accepts connections and serves read-only queries.
2
16 reads
CURATED FROM
IDEAS CURATED BY
Alt account of @ocp. I use it to stash ideas about software engineering
Similar ideas to Server roles in a Postgres cluster
Performance and scale
- Each Frontend node handles 100k persistent connections. It handles only this many connections because the server is doing a lot of work processing multiple types of data (likes, comments, instant messaging etc.).
- Each Dispatcher can publish 5k events per seco...
Shopping as a bonding activity
Shopping can be a bonding activity between friends and family members. But making positive connections with people you don't know (offering a cashier a warm thanks for example) has a remarkably powerful impact on well-being and even physical health.
These short moment...
EMBRACE UNCERTAINTY
Uncertainty is a part of life, and we need to learn to embrace it. Mark Manson argues that trying to control everything in our lives is a fool's errand, and that we will only end up feeling stressed and anxious.
Manson says that the best way to deal with uncertainty is to a...
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Personalized microlearning
—
100+ Learning Journeys
—
Access to 200,000+ ideas
—
Access to the mobile app
—
Unlimited idea saving
—
—
Unlimited history
—
—
Unlimited listening to ideas
—
—
Downloading & offline access
—
—
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates