No upcoming presentations...

    In this session, we will discuss ways to offload SQL for low latency; all without code changes. We will discuss how database proxies (commercial and open-source) can intelligently cache, split and route queries for optimal Postgres performance and scale. During the presentation, it will be an interactive discussion with Q&A. Come join us.

    @ Silicon Valley 2023

    Apr 20 2023

    Dev

    Database proxies manage connections to improve performance and scale. In this session, we will highlight deficiencies of open-source 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 failover...
    

    @ Silicon Valley 2022

    Apr 7 2022

    Ops

    Improve Write-Master and Read Replica scale, safely without application changes

    Read/Write split and Replication lag detection made easy with a database proxy

    Horizontally scaling your SQL database involves separating the write-master from read-only servers. However, writing to one node and reading from another can result in inconsistent data due to synchronization delays.

    Database proxies intelligently route SQL queries to the best data source for even load distribution, while guaranteeing consistency.

    In this session, we will provide a hands...

    @ Postgres Conference 2020
    Ops and Administration

    How the Heimdall Proxy Improved SQL Scale for the World's #1 Coffee Retailer

    Query Caching and Read/Write splitting without code change

    In this session, we will go over a customer use case of how the Heimdall Database Proxy offloaded and improved database scale for one of the world's largest coffee retailer. We will discuss features and solutions used to diagnose and cure bottlenecks. As the backend infrastructure has been the culprit of many application performance issues, Database Proxies in the market can save development an...

    @ Silicon Valley 2019

    Sep 19 2019

    Case Studies

    Improve Database Warehouse Performance 100x with a Database Proxy

    Increase Amazon Redshift and Pivotal Greenplum Concurrency

    Data Analytics/Warehouse solutions are often challenged with slow application response times caused by 1) High latency and 2) Frequent queries to the backend.

    Heimdall Data is a Database Proxy that leverages Postgres for query optimization to improve the performance of Data Warehouse solutions (e.g. Amazon Redshift, Pivotal Greenplum). Techniques include batch processing and materialized vi...

    @ Silicon Valley

    Oct 15 2018

    Ops