Date: 2024-10-01
Time: 11:40–12:30
Room: The Hub
Level: Intermediate
Although the application layer is the portion the world accesses for many cloud architectures, it seems that we rarely consider how we can optimize our application for the database we’re using. When using any relational database engine, it’s important to consider not just schema design, but understanding how databases read and write data to their storage systems to ensure the application is manageable, scalable, and performant.
In this talk, we will discuss key PostgreSQL terms, then we dive a bit deeper into autocommit, autovacuum, and idle in transaction when using PostgreSQL