The latest articles on DEV Community by manishhub9 (@manishhub9). https://dev.to/manishhub9 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F125298%2F185309df-9387-4ad1-b247-47236fe23f72.jpeg https://dev.to/manishhub9 en manishhub9 Fri, 05 Apr 2019 07:46:03 +0000 https://dev.to/manishhub9/postgresql-index-a-life-savior-2oe8 https://dev.to/manishhub9/postgresql-index-a-life-savior-2oe8 <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--2Qea3SIt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://thepracticaldev.s3.amazonaws.com/i/epes6ehk5aa7bv24xqyq.jpg" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--2Qea3SIt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://thepracticaldev.s3.amazonaws.com/i/epes6ehk5aa7bv24xqyq.jpg"></a></p> <p>I am using postgres from last 1 year for my Django project. At the beginning of my project my database response is good but after some time when my project get some user it take more and more time. Then i start doing research to fix my response time. Then i found postgres index, we user postgres index to minimize the query cost. In postgres cost is related to pages. If their a large number of pages then the query cost is also high. For illustrate i will take a simple example that i posted on slideshare.</p> <p><a href="https://www.slideshare.net/manishyadav143341/postgre-sql-index">https://www.slideshare.net/manishyadav143341/postgre-sql-index</a></p> postgres scalingpostgresql