Back to article
use-the-index-luke.com

Use the Index Luke – A Guide to Database Performance for Developers (opens in new tab)

Covered by 3 sources See all sources covering this story including DEV Community, Hacker NewsDiscussed on Hacker News and Hacker News

Covered in 4 articles

DEV Community·

PostgreSQL Indexing Deep Dive - Choosing the Right Index

Discussed on DEV
Feeds
DEV Community·

Debugging PostgreSQL Performance

Discussed on DEV
Feeds
Hacker News·

Learn SQL Once, Use It for 30 Years

Discussed on Hacker News
Feeds
sharafath.hashnode.dev·

My PostgreSQL query went from 57ms to 1.4ms on a 1 million + row table. I didn't change the query. Here's what I did.

Discussed on r/web_design
Feeds

Keyboard Shortcuts

Navigation

Next / previous post
j/k
Open post
oorEnter
Preview post
v

Post Actions

Love post
a
Like post
l
Dislike post
d
Undo reaction
u
Save / unsave
s

Recommendations

Add interest / feed
Enter
Not interested
x

Go to

Home
gh
Interests
gi
Feeds
gf
Likes
gl
History
gy
Changelog
gc
Settings
gs
Discover
gb
Search
/

General

Show this help
?
Submit feedback
!
Close modal / unfocus
Esc

Press ? anytime to show this help