Upcoming presentations
No upcoming presentations...
Past presentations
- Connection pooling
- Read/write split with Strong Consistency
- Query caching
- Persisted connection, automated Postgres failove...
- 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.
Scaling Beyond Pg-Bouncer & Pg-Pool-II: Advanced Traffic Management
Improve Postgres Scale with Database Proxies
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:
Join us in learning all about Enterprise Connection Pooling and Authentication with Postgres! In this digital breakout session you will learn how to:
Improve Postgres Transaction/Second with a Database Proxy, no code changes required
Get the most out of your Postgres DB without application changes
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...
Authentication & Authorization with Multi-User Connection Pooling for Large-scale Postgres Deployments
How to scale high Enterprise connection counts for Postgres
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...
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
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...
Automated Failure Management and Caching, with no code changes
PGPool replacement and Auto-caching without the programming
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...
Join Heimdall Data for a Workshop on Automatic Failover and Caching for PostgreSQL.
Automated Postgres Failover and Caching with Zero Code Changes
Improve application performance and reliability in minutes without the development work
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...