Topic

PostgreSQL

8 articles

Showing 8 of 8
Shopify Engineering

Querying Strategies for GraphQL Clients - Shopify

As more clients rely on GraphQL to query data, we witness performance and scalability issues emerging. We share some query strategies for GraphQL at scale.

10 min read
Instacart Tech & Innovation

Zero-Downtime PostgreSQL Cutovers | Instacart

Authors: Brad Nicholson, Andrew Tanner, Marco Montagna Instacart runs one of the largest PostgreSQL fleets on top of AWS RDS, and part of managing a fleet like this is to keep it up to date....

Person13 min read
Instacart Tech & Innovation

Adopting PgCat: A Nextgen Postgres Proxy | Instacart

Authors: Mostafa Abdelraouf, Zain Kabani, Andrew Tanner In this post, we’ll be talking about PgCat , an open-source Postgresql Proxy that we have been using in production and contributing to. It provides connection pooling, load-balancing,...

Person13 min read
Spotify Engineering

Switching user database on a running system | Spotify Engineering

All Spotify users are now stored in a Cassandra database instead of Postgres. The final switch was made on May 11th, and we, the team responsible for user login at Spotify, would like to tell you a little bit about this endeavour.

Marcus Vesterlund10 min read
Instacart Tech & Innovation

How Instacart Built a Modern Search Infrastructure on Postgres | Instacart

Authors: Ankit Mittal, Vinesh Gudla, Guanghua Shu, Akshay Nair, Tejaswi Tenneti, Andrew Tanner In a previous blog post “ Improving search at Instacart using hybrid recall ”, we shared our progress on adaptively combining traditional...

Person16 min read