Upcoming presentations
No upcoming presentations...
Past presentations
3 Techniques to Improve Postgres Response Times without Code Changes
Improve Performance via SQL Offload
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.
Scaling Beyond PgBouncer & Pgpool-II: Advanced Traffic Management
Survey of Database Proxies
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...
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...
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...
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...