---
title: "Discussion on \"𝐅𝐫𝐨𝐦 23 𝐒𝐞𝐜𝐨𝐧𝐝𝐬 𝐭𝐨 1.3 𝐌𝐢𝐥𝐥𝐢𝐬𝐞𝐜𝐨𝐧𝐝𝐬: 𝐀 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐃𝐞𝐭𝐞𝐜𝐭𝐢𝐯𝐞 𝐒𝐭𝐨𝐫𝐲(𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐏𝐫𝐨𝐣𝐞𝐜𝐭)\" | Hashnode"
description: "Discussion on \"𝐅𝐫𝐨𝐦 23 𝐒𝐞𝐜𝐨𝐧𝐝𝐬 𝐭𝐨 1.3 𝐌𝐢𝐥𝐥𝐢𝐬𝐞𝐜𝐨𝐧𝐝𝐬: 𝐀 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐃𝐞𝐭𝐞𝐜𝐭𝐢𝐯𝐞 𝐒𝐭𝐨𝐫𝐲(𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐏𝐫𝐨𝐣𝐞𝐜𝐭)\". (Or: How I learned to stop worrying and love the Query Plan)\nI built a URL Shortener. It was simple. It was elegant. It worked perfectly on my laptop with 50 rows of data.\nThen, I loaded 100,000 rows of historical data to simulate a real production e..."
url: "https://hashnode.com/posts/postgres-optimization-23s-to-1ms/694ad610bd0a6569de3ed8ae"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [𝐅𝐫𝐨𝐦 23 𝐒𝐞𝐜𝐨𝐧𝐝𝐬 𝐭𝐨 1.3 𝐌𝐢𝐥𝐥𝐢𝐬𝐞𝐜𝐨𝐧𝐝𝐬: 𝐀 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐃𝐞𝐭𝐞𝐜𝐭𝐢𝐯𝐞 𝐒𝐭𝐨𝐫𝐲(𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐏𝐫𝐨𝐣𝐞𝐜𝐭)](https://krishnavulchi.com/postgres-optimization-23s-to-1ms?utm_source=hashnode&utm_medium=feed)

(Or: How I learned to stop worrying and love the Query Plan) I built a URL Shortener. It was simple. It was elegant. It worked perfectly on my laptop with 50 rows of data. Then, I loaded 100,000 rows of historical data to simulate a real production e...

Dec 23, 2025 · 4 min read · krishnavulchi.com  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#indexing-strategy](https://hashnode.com/tag/indexing-strategy)

## Written by

[krishna chaitanya](https://hashnode.com/@krishnavulchi)

@krishnavulchi

  
[View profile](https://hashnode.com/@krishnavulchi)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
