No upcoming presentations...

    Good bye sequences, hello Snowflakes

    A detailed look at the problems sequences pose in replication and how to overcome them.

    Sequences and serial columns have been a problem when it comes to logical database replication since the days of Slony-I. In this talk we take a look at different ways to avoid replicating sequences in the first place and how Snowflake IDs can help solve the problem, especially as we move to multi-master systems.

    @ Postgres Conference 2024

    Apr 17 2024

    Ops

    As the Inventor of Slony-I, I present to you Spock

    Multi-Active Logical Replication for PostgreSQL

    Full support of multi-active logical replication in pgLogical has gone unsupported for many years. In this talk we will discuss the work we have done to bring back multi-active replication in a new derivative of pgLogical we call Spock. Spock is available as an open source PostgreSQL extension under a community open source license.

    High performance web applications increasingly need present...

    @ Silicon Valley 2023

    Apr 20 2023

    Data

    The new PL profiler allows you to easily get through the dark barrier, PL/pgSQL puts between tools like pgbadger and the queries, you are looking for. Query and schema tuning is tough enough by itself. But queries, buried many call levels deep in PL/pgSQL functions, make it torture. The reason is that the default monitoring tools like logs, pg_stat_activity and pg_stat_statements cannot penetra...

    @ PGConf US 2017 [PgConf.US]
    Development

    Join the OpenSCG team for a hands on look on how to migrate an application from Oracle to PostgreSQL.

    @ PGConf US 2017 [PgConf.US]

    Understanding PostgreSQL IO

    An in depth look into how your IO capacity is used

    Like any database, PostgreSQL is very dependent on the system's IO. In many situation's a poor performing database is directly related to how PostgreSQL is reading or writing to the disk and using memory. A key factor in improving performance is understanding how PostgreSQL is interacting with these resources.

    In this talk I will discuss the interactions between shared buffers, OS buffers, ...

    @ PostgresConf US 2018

    Apr 18 2018

    Postgres Internals