Avtandil UshikishviliHow Instagram Solved the “Justin Bieber Problem” Using PostgreSQL Denormalization“When we built Instagram, we never anticipated the scale of engagement driven by celebrity accounts. The ‘Justin Bieber Problem’ forced us…Jan 6Jan 6
Intech-at-instacartbyManas PaldheFrom Postgres to Amazon DynamoDBInstacart is the leading online grocery company in North America. Users can shop from more than 75,000 stores with more than 500 million…Nov 21, 20223Nov 21, 20223
Aleksei NovikovFrom JDBC to Spring Data for beginners. Part 1Database communication in Java can be achieved through various technologies, such as JDBC, JPA, Hibernate, and Spring Data. These…Feb 13, 2024Feb 13, 2024
Biagio TozziAdvanced and dynamic searching with Spring Data JPAI have often been asked to develop advanced search services. By advanced search I mean searches in which it’s possible to apply multiple…Jan 29, 20249Jan 29, 20249
InCapital One TechbyCapital One TechHow to use pgTAP to automate unit testing in postgresBenefits of automated database testingFeb 2, 20241Feb 2, 20241
Intech-at-instacartbyMostafa AbdelraoufAdopting PgCat: A Nextgen Postgres ProxyAuthors: Mostafa Abdelraouf, Zain Kabani, Andrew TannerMar 13, 20234Mar 13, 20234
Naveed AhmedSetting up replication in PostgreSQL with pglogicalTo get high-availability with PostgreSQL, you definitely want to set up replication. My preferred approach is to set up the database…Oct 4, 20201Oct 4, 20201
Pankaj kushwahaSetting up and switching PostgreSQL active/standby environment on Linux1. Concept Database hot standby: Database hot standby refers to the creation, maintenance, and monitoring of one or more standby databases…Jun 23, 2020Jun 23, 2020
InAdyen TechbyAdyenA Deep Dive into Table Partitioning part 1 🐰: Introduction to Table PartitioningBy Cosmin Octavian Pene(Java Engineer) & Derk van Veen (Database Engineer) , AdyenJul 7, 20232Jul 7, 20232
InThe StartupbyEresh GorantlaPerformance Optimisation for Wildcards Search in Postgres (Trigram Index)I am working on one of my projects where Postgres happens to be the relational database and has a big table, currently had 10 Million…Oct 24, 20203Oct 24, 20203
InWebtipsbyNeelesh DwivediUsing indexes in an intelligent way!Are indexes always good to use?Aug 10, 2020Aug 10, 2020
Asheet BhaskarTime-based table partitioning using pg partmanTable partitioning is splitting of a large table in smaller tables based on values of some attribute in the table. This post is about…Oct 4, 20182Oct 4, 20182
Yash MaratheAnalyzing Postgres Queries with Database IndexingA practical example for understanding how indexes make databases read fasterMar 26, 2023Mar 26, 2023
InPreply Engineering BlogbyViktoriia RomanchenkoPostgreSQL schema-change gotchasThis articles describes a few cases where a migration might look good, but it can cause downtimes anyway. I’ve included a “what to do”…Feb 15, 2021Feb 15, 2021
InEngineering @ Housing/Proptiger/MakaanbyRishabh SairawatPartitioning Postgres TablesIn this post, I will describe what table partitioning is and how we can create & manage table partitions. We, at housing.com, are using the…Apr 4, 20221Apr 4, 20221
