PinnedMOHAMMAD SAMSAD HUSSAIN·Feb 11How PostgreSQL Materialized Views Power Fast Food Delivery AppsLearn how materialized views reduce query time from 200ms to under 1ms and dramatically improve PostgreSQL performance.
PinnedMOHAMMAD SAMSAD HUSSAIN·Jan 23Do Indexes Eliminate PostgreSQL Sort Costs? (Part 4)Group D — Final Experiment: Index-Driven Ordering
MOHAMMAD SAMSAD HUSSAIN·Feb 18MVCC Bloat in PostgreSQL: Why Your Database Size Keeps Growing Even After Deleting Data: Part 1It’s 2:00 AM. Your monitoring system suddenly screams: “Disk usage: 95% full.”
MOHAMMAD SAMSAD HUSSAIN·Jan 15Why work_mem Is the Only Setting That Actually Changes PostgreSQL Sorting : Part 3🍀 In Part 1, we learned that doubling system RAM barely changed PostgreSQL’s behavior. 🍀 In Part 2, we killed another myth: increasing…
MOHAMMAD SAMSAD HUSSAIN·Jan 13Why Increasing shared_buffers Didn’t Fix My PostgreSQL Sort : Part 2Disk spills, external merge sorts, and the biggest caching myth in PostgreSQL
MOHAMMAD SAMSAD HUSSAIN·Jan 5Why Doubling RAM Didn’t Speed Up PostgreSQL — and One Setting That DidI doubled the RAM on my PostgreSQL server. 🟥🟪🟦🟩🟨🟧
MOHAMMAD SAMSAD HUSSAIN·Dec 23, 2025PostgreSQL Architecture: A Journey from Your Query to the DiskPostgreSQL power emerges not from a single component, but from the synergy of its processes, memory, and storage; an architecture…
MOHAMMAD SAMSAD HUSSAIN·Apr 12, 2024Leveraging AI: Friend or Foe to Your Job?Artificial intelligence (AI) is quickly changing our world, and the workplace is not an exception at all. Although the media often…