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.
https://www.slideshare.net/manishyadav143341/postgre-sql-index
Top comments (0)