Courses
  • Our latest Blogs

  • PostgreSQL Memory Optimization.

    PostgreSQL Performance Learning: Index, Parallelism & Memory Behavior Step 1: Creating and Loading DataThen we insert 1.5 million rows using generate_series(): Step 2: Query Execution Plan (Seq Scan) PostgreSQL chooses Sequential Scan Because no index exists It estimates full table read is cheapest Step 3: Understanding Planner Statistics Step 4: Cost Model Understanding.PostgreSQL uses a cost formula:CPU tuple…

  • PostgreSQL Performance Learning: Index, Parallelism & Memory Behavior

    A Practical DBA Experiment by PetaCore Tech Step 1: Creating and Loading DataThen we insert 1.5 million rows using generate_series(): Step 2: Query Execution Plan (Seq Scan) PostgreSQL chooses Sequential Scan Because no index exists It estimates full table read is cheapest Step 3: Understanding Planner Statistics Step 4: Cost Model Understanding.PostgreSQL uses a cost…