How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (2024)

Devi Das

SDE-2 @Mphasis | Full Stack Developer | 7+ Industry Exp. | C# | .NET Core | TDD | REST API | GCP | Azure | SOA | Microservices | DDD | Kafka | SQL | Angular | Typescript 🚀| React | Javascript ❤️ | Mentor | Speaker

  • Report this post

🚀Scaling Reddit with PostgreSQL: 100k requests/second at 17ms (p99) 🔥Impressed by how the Reddit engineering team uses PostgreSQL to handle massive traffic. Their metadata store scales to 100k requests/second at a p99 latency of 17ms!This efficiency is achieved with a combination of PostgreSQL and powerful extensions:🎯 pgbouncer: Manages connection pooling for efficient resource utilization.🎯 pg_partman: Enables intelligent data partitioning for optimized querying.🎯 pg_cron: Automates routine maintenance tasks for a smooth-running database.Thanks to Arpit Bhayani 😊YouTube videohttps://lnkd.in/gMkc8wP8Reddit article blog 👩🏽💻https://lnkd.in/g3ZDJRqE #PostgreSQL #DatabaseScaling #Reddit #developer #backend #database #db #coding #fullstackdeveloper #dev #code #optimization #design #designpatterns #scale #enginnering #developerlife #pgbouncer #pg_partman #pg_cron #Reddit #Engineering #reddit #TechTalk #PostgreSQL

How Reddit designed their metadata store to serve 100k req/sec at p99 of 17ms

https://www.youtube.com/

35

Like Comment

To view or add a comment, sign in

More Relevant Posts

  • Raghunath Gopinath Nair

    Machine Learning Engineer bij Rabobank | 16K+ LinkedIn Followers | 2.5M Impressions

    • Report this post

    I really enjoyed the cassandra app written in rust! 🔔 Kudos to Piotr Kołaczkowski! for this beautiful post. (already devouring rust with those two session articles) 📍 #cassandra #rust #nosql #distributedsystems #data #database

    Developing High Performance Apache Cassandra™ Applications in Rust (Part 1) | Datastax datastax.com

    2

    Like Comment

    To view or add a comment, sign in

  • Ryan Edge

    Freelancer | Google Developer Expert for Flutter | Organizer of Flutter Charlotte

    Finally finished porting my Dart full-stack reference project demonstrating: - A serverless API built with the Nitric.io framework - Integrating a pre-existing Supabase.com Postgres database - Passage.id passwordless authentication- Shared logic for serialization/deserializationI'll make it public eventually.

    15

    5 Comments

    Like Comment

    To view or add a comment, sign in

  • Steven Tey

    Founder & CEO at Dub.co – we're hiring!

    • Report this post

    Just dropped a new Vercel guide on vector databases → https://lnkd.in/gNFPPWAESome highlights:◆ What is a vector database?◆ Some of the best of vector databases in 2023◆ Building a semantic search app with Vercel Postgres + pgvector

    • How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (11)

    62

    5 Comments

    Like Comment

    To view or add a comment, sign in

  • InfluxData

    18,951 followers

    • Report this post

    If you missed Data Council 2024, fear not—you can watch InfluxData Staff Engineer Andrew Lamb's session on the latest advancements in database design. 📺 Andrew says the future of database design is not building from the ground up, but building a database with reusable components—like we did with InfluxDB 3.0 and the FDAP stack.⭐ FDAP = Flight, DataFusion, ApacheArrow, & Parquet ⭐https://bit.ly/3xUukpe#Database #OpenSource #InfluxDB

    Building InfluxDB 3.0 with Apache Arrow, DataFusion, Flight and Parquet

    https://www.youtube.com/

    80

    1 Comment

    Like Comment

    To view or add a comment, sign in

  • Roi Katz

    Principal Solutions Engineer/Architect at Couchbase

    • Report this post

    #Couchbase plugin-developers ecosystem is strong, come and join us in this virtual meetup to learn more how to use it with VScode and JetBrains platforms!

    3

    Like Comment

    To view or add a comment, sign in

  • Stephan 🚀 Schmidt

    Bestselling Author "Amazing CTO" • CTO Coach • 25+ years leadership in tech • ex-eBay • ex-ImmoScout • Helping you master all challenges

    • Report this post

    Hurray to #RadicalSimplicity - Current stack for #Inkmi - #Go - Echo / Jet - Templ for fragments - @htmx_org for forms to post JSON- @Alpine_JS for dynamic elements - Postgres for storageThe progress bar is a Templ fragment rendered into Jet.https://www.inkmi.com - #JobsForCTOshttps://lnkd.in/diTD5UHe - #RadicalSimplicity

    • How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (22)

    3

    3 Comments

    Like Comment

    To view or add a comment, sign in

  • Andy Yun

    • Report this post

    Will we be seeing you at #PASSDataSummit 2023? I have the honor of teaming up with Jeff Iannucci and Deborah Melkin to bring you a Learning Pathway, with 5 sessions all focused around Solving Your Real World SQL Server Problems! Check out this quick promo code to learn more about our sessions!

    43

    2 Comments

    Like Comment

    To view or add a comment, sign in

  • Eyal Nussbaum

    Solutions Architect

    • Report this post

    Join this upcoming Meetup on April 10 to see how to make your database work more enjoyable with the #Couchbase Plugin for the JetBrains and VSCode platforms.

    Upcoming Meetup: NoSQL Made Easy with JetBrains and VSCode Plugins meetup.com

    7

    Like Comment

    To view or add a comment, sign in

  • InfluxData

    18,951 followers

    • Report this post

    🤔 The problem with columnar databases is that querying methods become a bottleneck. 💡 Join this session at the DataConnect Conference to learn how to leverage OSS projects like Apache Arrow Flight & Apache Parquet alongside industry-standard analytics libraries to build the foundations of a performant analytics application for time series data.Sign up now.https://bit.ly/3NWo3PM#InfluxDB #OpenSource #DataConnectConf #DataConnect2023

    DataConnect Conference dataconnectconf.com

    1

    Like Comment

    To view or add a comment, sign in

How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (34)

How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (35)

5,390 followers

  • 106 Posts

View Profile

Follow

Explore topics

  • Sales
  • Marketing
  • Business Administration
  • HR Management
  • Content Management
  • Engineering
  • Soft Skills
  • See All
How PostgreSQL handles massive traffic | Devi Das posted on the topic | LinkedIn (2024)

References

Top Articles
51 Easy Vegan Pantry Recipes
10 Tasty Recipes That Use Acorns
Bild Poster Ikea
jazmen00 x & jazmen00 mega| Discover
Patreon, reimagined — a better future for creators and fans
Part time Jobs in El Paso; Texas that pay $15, $25, $30, $40, $50, $60 an hour online
Nyu Paralegal Program
Evil Dead Rise Showtimes Near Massena Movieplex
Hertz Car Rental Partnership | Uber
Beds From Rent-A-Center
Whiskeytown Camera
Midway Antique Mall Consignor Access
OnTrigger Enter, Exit ...
Vichatter Gifs
1Win - инновационное онлайн-казино и букмекерская контора
Nioh 2: Divine Gear [Hands-on Experience]
Summer Rae Boyfriend Love Island – Just Speak News
Craigslist List Albuquerque: Your Ultimate Guide to Buying, Selling, and Finding Everything - First Republic Craigslist
Sivir Urf Runes
[Birthday Column] Celebrating Sarada's Birthday on 3/31! Looking Back on the Successor to the Uchiha Legacy Who Dreams of Becoming Hokage! | NARUTO OFFICIAL SITE (NARUTO & BORUTO)
NHS England » Winter and H2 priorities
Mikayla Campinos Laek: The Rising Star Of Social Media
Rugged Gentleman Barber Shop Martinsburg Wv
A Biomass Pyramid Of An Ecosystem Is Shown.Tertiary ConsumersSecondary ConsumersPrimary ConsumersProducersWhich
Aes Salt Lake City Showdown
25 Best Things to Do in Palermo, Sicily (Italy)
Wiseloan Login
Why Are Fuel Leaks A Problem Aceable
Mcclendon's Near Me
What does wym mean?
O'reilly Auto Parts Ozark Distribution Center Stockton Photos
Walter King Tut Johnson Sentenced
Www Violationinfo Com Login New Orleans
Pickle Juiced 1234
Craigslist Mount Pocono
Skill Boss Guru
888-333-4026
Wayne State Academica Login
Smite Builds Season 9
Citibank Branch Locations In North Carolina
Courses In Touch
Csgold Uva
Sandra Sancc
Canvas Elms Umd
Phone Store On 91St Brown Deer
25100 N 104Th Way
Wvu Workday
Sml Wikia
Raley Scrubs - Midtown
March 2023 Wincalendar
Strange World Showtimes Near Century Federal Way
Fishing Hook Memorial Tattoo
Latest Posts
Article information

Author: Dr. Pierre Goyette

Last Updated:

Views: 5438

Rating: 5 / 5 (50 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Dr. Pierre Goyette

Birthday: 1998-01-29

Address: Apt. 611 3357 Yong Plain, West Audra, IL 70053

Phone: +5819954278378

Job: Construction Director

Hobby: Embroidery, Creative writing, Shopping, Driving, Stand-up comedy, Coffee roasting, Scrapbooking

Introduction: My name is Dr. Pierre Goyette, I am a enchanting, powerful, jolly, rich, graceful, colorful, zany person who loves writing and wants to share my knowledge and understanding with you.