Skip to content

Bhanu's Blog

it's not about being the best it's about being better than yesterday

Bhanu's Blog

it's not about being the best it's about being better than yesterday

Day: March 28, 2023

Tech

TIL – How to optimize postgres database by removing indexes

  • bhanunadar
  • Posted on March 28, 2023

Are you looking to optimize your database, the best go-to way is to add an index to execute your query faster, but this blog is not about adding indexes but removing them, why do we need to remove indexes from our table? Having lots of indexes can have several disadvantages, including: Increased disk space usage:…

Read More

Recent Posts

  • TIL: Docker Namespaces
  • My Experience with LG Ultragear 32GS60QC (32 inch)
  • TIL: Value Classes
  • Counting Subarrays Where the Max Appears At Least K Times (LeetCode 2962)
  • Solo motorcycle trip to Ratnagiri from Mumbai

Copyright © All rights reserved. Proudly powered by WordPress | Theme: Blog Nano by ThemeMiles.