DEV Community

manishhub9
manishhub9

Posted on

1 1

PostgreSQL index a life savior

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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

πŸ‘‹ Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay