Schedule - PGDay Chicago 2023

    Exploring the Limits of Postgres as a Data Store

    Date: 2023-04-20
    Time: 10:50–11:40
    Room: Room 3
    Level: Intermediate

    To a non-techy, a database is used to store every kind of data. From usernames to passwords, and from tweets to images. In reality, this is rarely the case, but why is that? What about Postgres makes it a sub-optimal solution to store large files when we have data types like bytea, Large Object (BLOB), and functionality like TOAST? What are some use cases where it makes sense to store files in Postgres? How does Postgres compare as an object store to AWS S3 and Azure Blob Storage, etc in speed, cost, and ease of use? Join me as I try to answer these questions in a comprehensible way using straightforward code, benchmarks, and interesting graphs.


    Mathis Van Eetvelde