Talks
Speakers
Events
Topics
Sign in
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
Suggest modification to this talk
Title
Description
Postgres at Any Scale by Will Leinweber This is a sponsored talk by Citus Data. Postgres has powerful datatypes and a general emphasis on correctness which makes it a great choice for apps small and medium. Growing to very large sizes has been challenging—until now! First you'll learn how to take advantage of all PG has to offer for small scales, especially when it comes to keeping data consistent. Next you'll learn techniques for keeping apps running well at medium scales. And finally you'll learn how to take advantage of the open-source Citus extension that makes PG a distributed db, when your app joins the big leagues.
Date
Summarized using AI?
If this talk's summary was generated by AI, please check this box. A "Summarized using AI" badge will be displayed in the summary tab to indicate that the summary was generated using AI.
Show "Summarized using AI" badge on summary page
Summary
Markdown supported
In the talk "Postgres at Any Scale," Will Leinweber discusses the versatility of PostgreSQL (Postgres) for applications of varying sizes at RailsConf 2017. He emphasizes its strengths for small and medium-sized applications and provides strategies for scaling to a large database efficiently with the help of the open-source Citus extension. The presentation is structured into three key segments, each focusing on different data scale stages: - **Small Scale**: Leinweber highlights the initial stage of database operation, where he advises developers to embrace Postgres features like constraints, ensuring data integrity. Important practices include: - Taking regular backups using `pg_dump` and testing the restore process to ensure integrity. - Setting up constraints at the database level (e.g., NOT NULL, unique indexes) to prevent data inconsistencies early on. - Utilizing Postgres’s powerful data types, such as JSONB for semi-structured data. - **Medium Scale**: As applications grow, the talk transitions to medium-scale strategies (over 100 GB). Key points include: - The importance of transitioning to logical backups with tools like Wally, which captures write-ahead logs for recovery. - Implementing hot standbys for redundancy and reliability when managing increasing data loads. - Emphasizing the need for monitoring and alerting to catch issues early. - **Large Scale**: In the final segment, the focus shifts to large-scale handling, introducing sharding strategies using the Citus extension. - This allows for the distribution of data across multiple nodes, effectively overcoming the limitations of a single server. - Citus simplifies the development of multi-tenant applications by ensuring that user data remains isolated, promoting performance and maintainability. - He suggests that architects should think about how their applications will utilize distributed databases efficiently, not just at the code level but also in the database schema design. In conclusion, the talk reassures developers that with the right strategies and tools, Postgres can be an excellent choice for applications of any scale, encouraging best practices for data management right from the start.
Suggest modifications
Cancel
