About

Erik Brandsberg is CTO at Heimdall Data. He specializes in application-networking technologies for web and backend data. Whether it's coding, testing or installing, he has been involved. His diverse experience at Alteon, Citrix, and Juniper Networks gave him a solid understanding of operational complexities in a modern infrastructure, which led to the founding of Heimdall Data.


     Erik Brandsberg Scaling Beyond Pg-Bouncer & Pg-Pool-II: Advanced Traffic Management
    Improve Postgres Scale with Database Proxies

    presented by Erik Brandsberg


    video

    Database proxies intelligently manage Postgres connections to improve performance and scale. In this session, we will highlight deficiencies of Pg-bouncer and Pg-Pool-II that users should know, and propose solutions. Features to be discussed include:

    • Connection pooling
    • Read/write split with Strong Consistency
    • Query caching
    • Persisted connection, automated Postgres failove...
    more

    Tue 30 2021 Ops
     Erik Brandsberg Enterprise Authentication and Connection Pooling

    presented by Erik Brandsberg


    video

    Join us in learning all about Enterprise Connection Pooling and Authentication with Postgres! In this digital breakout session you will learn how to:

    • Reduce Postgres resource utilization with with per user and global connection pooling limits.
    • Simplify database access management with 1) Active Directory and LDAP and 2) Group extraction for Postgres.

    Wed 12 2020 Ops
     Erik Brandsberg Improve Postgres Transaction/Second with a Database Proxy, no code changes required
    Get the most out of your Postgres DB without application changes

    presented by Erik Brandsberg

    In this session, we will demonstrate how a database proxy can be deployed in minutes to improve read/write transaction/sec (TPS). We will cover typical operations challenges and ways to solve to improve scale with: 1) Query caching, 2) Granular connection pooling, and 3) Read/write split with replication lag detection. No application changes required for deployment.

    Technical hands-on demo a...

    more

    Ops and Administration
     Erik Brandsberg Authentication & Authorization with Multi-User Connection Pooling for Large-scale Postgres Deployments
    How to scale high Enterprise connection counts for Postgres

    presented by Erik Brandsberg

    Most Postgres deployments support a limited number of users to the database. Users are typically managed manually by the DBA. In this session, we will explore how database proxies manage users at high scale quickly and easily: We will cover:

    Full Authentication/Authorization/Auditing (aka AAA) over database access: - Authentication of the user via Active Directory/LDAP - Group extraction a...

    more

    Ops and Administration
     Erik Brandsberg Zack Odom Learn how Dell Computer Improved Postgres/Greenplum Performance 20x with a Database Proxy
    How database proxies optimize query read/write performance with no code changes

    presented by Erik Brandsberg and Zack Odom

    Learn the various techniques on how Heimdall's Database Proxy improved throughput and performance:

    1) Batch DML operations: intelligently process singleton operations as micro-batches. 2) Intelligently route diverse workloads (i.e. OLTP, OLAP) to Postgres, utilizing Postgres's latest features, such as materialized views for analytic purposes. 3) Auto-caches into GemFire or other cache eng...

    more

    Wed 20 2019 Data
     Erik Brandsberg Automated Failure Management and Caching, with no code changes
    PGPool replacement and Auto-caching without the programming

    presented by Erik Brandsberg

    Implementing Postgres failover and caching requires development work and adds risk. What if there was a solution that removes these complexities?

    In this session, we will demonstrate how Heimdall Data is deployed in minutes as a PgPool-II replacement and supports automated, distributed caching for improved performance.

    Heimdall Data intelligently caches, invalidates and synchronizes ac...

    more

    dev
     Erik Brandsberg Automatic Failover and Caching Workshop

    presented by Erik Brandsberg

    Join Heimdall Data for a Workshop on Automatic Failover and Caching for PostgreSQL.

    Operations and Administration
     Erik Brandsberg Automated Postgres Failover and Caching with Zero Code Changes
    Improve application performance and reliability in minutes without the development work

    presented by Erik Brandsberg

    In this session, we will demonstrate how to implement failover (like PGPool-II) in minutes while adding automated caching for improved performance. Additional topics include monitoring, analyzing query performance, and read/write split to leverage read-only servers. Supported databases include open source Postgres, Greenplum, AWS Aurora for Postgres, and others, without change...

    more

    Wed 18 2018 Operations and Administration