Presented by:

Fc852a9622a6a83363d31d520b94605d

Christopher Travers

from Timescale

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.

No video of the event yet, sorry!

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

Happening at the same time:

  1. Introduction to 'WITH' Queries and their Materialization
  2. Start Time:
    2023 February 23 12:15

    Room:
    Grand Victoria 1

  3. Reducing PostgreSQL Costs in the Cloud
  4. Start Time:
    2023 February 23 12:15

    Room:
    Robusta + Arabica