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
14 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
What Is a Virtual Private Server?
Virtual private servers use virtualization technology to set up multiple virtual servers on a single physical server.
This is more affordable than paying for a dedicated server, because the costs are split across several users, but you still enjoy the added security of hav...
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...
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