Shahar ShokraniUnderstanding B-Tree Indexes in PostgreSQL, Ineffective for Low Cardinality ColumnsFollow up to Unlocking the Power of PostgreSQL Indexes.Aug 3Aug 3
Shahar ShokraniUnlocking the Power of PostgreSQL IndexesIndexes are essential for improving the performance of your PostgreSQL queries. They allow the database to find and retrieve specific rows…Jul 30Jul 30
Shahar ShokraniHandling Flexible JSON Formats in C#: A Case Study with JSON ConvertersIntroductionJul 21Jul 21
Shahar ShokraniUnderstanding fsync in PostgreSQL: Balancing Performance and DurabilityWhat is fsync?Jul 21Jul 21
Shahar ShokraniTicketMaster System DesignDesigning a system for a high-demand service like TicketMaster requires careful consideration of both functional and non-functional…Jul 18Jul 18
Shahar ShokraniCheckpoints in PostgreSQL: Ensuring Data Integrity and PerformanceWhat are checkpoints?Jul 13Jul 13
Shahar ShokraniUnderstanding Blocks in PostgreSQLPostgreSQL, like many relational databases such as MySQL, Oracle, and Microsoft SQL Server, organizes data writes into blocks…Jul 12Jul 12
Shahar ShokraniAppraoch For Handling Technical Debt in Development TeamsWhat is Technical Debt?Jul 5Jul 5
Shahar ShokraniTinyURL system design interview questionCreating a streamlined and efficient URL shortening system requires a comprehensive approach, focusing on link generation, scalability…Jun 24Jun 24