2ndQuadrant | PostgreSQL
Mission Critical Databases
+33 9 72 17 01 31
  • Contact
  • FR
    • EN
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Downloads
    • Installateurs
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • Bonnes Pratiques de Sécurité
    • Etudes de Cas
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Bases de Données Distribuées
        • ClickUp
        • European Space Agency (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Mises à Jour Bases de Données
        • Alfred Wegener Institute (AWI)
      • Support & Administration Base de Données
        • Met Office
        • Agilis Systems
        • London & Partners
  • Formation: Postgres Learning Center
    • Webinars
      • Archives – Webinar Library
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • Bonnes Pratiques de Sécurité
    • Blog
    • Formation
      • Catalogue des Formations
    • Etudes de Cas
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Distribués
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administration Bases de Données
        • Agilis Systems
      • Formation Professionnelle
        • Met Office
        • London & Partners
      • Mises à Jour Base de Données
        • Alfred Wegener Institute (AWI)
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Livres
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2ème Edition
      • PostgreSQL 9 Administration Cookbook – 3ème Edition
      • PostgreSQL Server Programming Cookbook – 2ème Edition
      • PostgreSQL 9 Cookbook – Edition en Chinois
    • Vidéos
    • PostgreSQL
      • PostgreSQL – L’Histoire
      • Qui Utilise PostgreSQL?
      • Foire aux Questions PostgreSQL
      • PostgreSQL et MySQL
      • L’Etude de Cas pour PostgreSQL
      • Informations de Sécurité
      • Documentation
  • Nous Connaître
    • Qui est 2ndQuadrant?
    • 2ndQuadrant: la Passion pour PostgreSQL
    • Actualités
    • Carrières
  • Blog
  • Installateurs
  • Menu Menu
Vous êtes ici : Accueil1 / tastyworks

tastyworks

Consultancy and Support from 2ndQuadrant for online trading platform boosts PostgreSQL performance by 400%

Download Case Study

tastyworks is a retail brokerage firm based in Chicago, IL that is leading a financial revolution for the do-it-yourself investor. It is a sibling company of tastytrade.com, which is one of the fastest growing online financial networks in the world. tastyworks is a wholly-owned subsidiary of tastytrade, Inc.

tastyworks provides a powerful and easy-to-use trading platform that interacts with the firm’s distributed microservices infrastructure. PostgreSQL was their database of choice, as the in-house team had previously implemented it in other parts of the company’s infrastructure. The database powering the tastyworks infrastructure was configured with basic replication and a baseline configuration suited for a mix of transactional and analytical workload. tastyworks subsequently launched in the brokerage sector, and began facilitating customer trades in January of 2017.

Challenge

Shortly after launching, the rapid success of the tastyworks platform created a larger than expected production volume, leading to unforeseen performance issues.

As the volume of the high throughput transactional workload grew, the technical team’s existing knowledge from running PostgreSQL on other projects did not provide insight into the specific performance and scalability issues that were manifesting. The team quickly realized that it would be necessary to diagnose bottlenecks and scale out the hardware appropriately to achieve immediate performance improvements and prepare the platform for future growth.

Faced with additional engineering and scaling challenges, the team felt a strong need to bring in specialists for architectural consultancy. tastyworks began to explore the options on how to best scale their database infrastructure and tackle performance issues simultaneously.

Solution

Tastyworks conducted thorough research and reached out to several PostgreSQL service providers to discuss consultancy services, database assessment, and support. 2ndQuadrant stood out above all others for having a more in-depth technical knowledge and superior services. tastyworks was especially impressed to see that the core PostgreSQL committers at 2ndQuadrant were directly involved in the consultancy and support services.

2ndQuadrant experts performed an architectural health check of tastyworks’ PostgreSQL database. A thorough analysis was conducted, which revealed a variety of sporadic performance issues that were responsible for slowing down the database. Consultancy services early on helped tastyworks pin down issues that were caused due to overzealous auto-analyze and auto-vacuum operations.

Performance Enhancements

After the analysis was completed, 2ndQuadrant recommended changes needed to ensure a high-performing database. Due to the critical nature of their data, tastyworks chose to have an in-house team implement the recommended changes. Coupled with 24/7 Production Support and the guidance of 2ndQuadrant Consultants, tastyworks was successful in optimizing their database by:

  • Implementing repmgr for replication between servers to easily manage High Availability, and enhancing overall productivity by reducing administrative overhead.
  • Introducing pgbouncer for connection pooling. Repmgr and Pgbouncer worked together in the scaling of the overall infrastructure and to reduce connection overhead.
  • Updating their PostgreSQL configuration and tuning Linux to meet best practices.
  • Designing, configuring, and seamlessly migrating to new, purpose-built server hardware for optimal performance and a substantial increase in headroom for forward growth.

After implementing these changes, tastyworks was able to scale their microservices infrastructure horizontally. This allowed them to manage thousands of simultaneous client connections while maintaining high levels of performance for the underlying PostgreSQL systems. This more robust architecture resulted in the ability to maintain high performing end-user trading platforms, even during periods of peak volume.

Deploying PGBouncer allowed us to stay ahead of performance issues that we knew we’d run in to due to increasing transactional volume. It was implemented in parallel with other re-engineering and performance optimization work and the impact was immediately noticeable. During our daily load test, we observed an immediate 2-4x improvement in peak throughput.

Jordan von Kluck, CTO, tastyworks

Seeing the drastic improvements in performance, tastyworks realized the importance of having PostgreSQL experts available around the clock, and they initiated a partnership with 2ndQuadrant under their 24/7 Platinum Support Plan.

Working with 2ndQuadrant has been an excellent experience. Their support team has a wealth of knowledge and always provides an in-depth answer to our questions in a very timely fashion. Between support, consulting on specific issues and guidance on overall best practices, 2ndQuadrant has been an invaluable resource to us at tastyworks.

Jordan von Kluck, CTO, tastyworks

Services Provided

  • 24/7 PostgreSQL Production Support
  • Architectural Health Check
  • Consultancy

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers – making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Faire défiler vers le haut
×