Redis vs PostgreSQL: Making the Right Choice
Presented by:
Christopher Travers
Chris Travers has worked with PostgreSQL since 1999, starting with version 6.5. He has worked as a software engineer, a database administrator and engineer, and an engineering manager in topics around PostgreSQL. He has experience working with databases of all sizes from a few megabytes to over a hundred terabytes (without sharding), and database environments from small embedded devices to multi-petabyte data storage environments.
Chris currently lives in Indonesia.
Checkout the slides
With the rise of NoSQL databases, a number of falsehoods have flourished regarding how to choose a database engine. This talk focuses specifically on Redis and PostgreSQL, and why one might choose one or the other.
At small scales, we can often get by thinking of database servers as black boxes, but as we scale, the internals and architecture become more and more important. This talk focuses on behavior of these systems at scale and under load.
In this presentation you will learn: - How Redis and PostgreSQL differ architecturally - How differences in architecture affect scalability and performance - Cases here Redis is the clear winner - Cases where PostgreSQL is the clear winner
Additionally, some notes will be offered in terms of where PostgreSQL can improve in to compete with the sorts of workloads that generally favor Redis.
- Date:
- 2023 February 23 - 12:15
- Duration:
- 45 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Application Developer
- Difficulty:
- Medium
- Reducing PostgreSQL Costs in the Cloud
- Start Time:
- 2023 February 23 12:15
- Room:
- Robusta + Arabica
- Introduction to 'WITH' Queries and their Materialization
- Start Time:
- 2023 February 23 12:15
- Room:
- Grand Victoria 1