No upcoming presentations...

    Bi-directional replication with PGlogical

    basic setup, monitoring, and lessons learned

    In the PostgreSQL ecosystem, we've been waiting for true bi-directonal replication for some time. While we've been promised this feature for some time, it's still not available in PostgreSQL core. There are several solutions that can provide us with this much sought-after feature, but the one we'll be talking about today is PGlogical.

    PGlogical is better know in the community as one of t...

    @ Postgres Conference 2020
    Ops and Administration

    Performance Impact of Idle PostgreSQL Connections

    A dive into how PostgreSQL manages connections and how idle connections consume resources.

    This presentation will provide an overview of how PostgreSQL manages connections and how idle connections impact performance.

    Following areas will be covered in this presentation:

    • Forking process used for each client connection
    • OS resources utilization
    • Results of various tests showing the resource utilization by idle connections
    • Performance impact of idle connections
    • Recomm...

    @ Postgres Conference 2020
    Ops and Administration