Depends what you want to do, I created a "estimate_count" function to make it mu... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		citilife on Dec 9, 2019 \| parent \| context \| favorite \| on: Building a Search Engine from Scratch Depends what you want to do, I created a "estimate_count" function to make it much much faster: "SELECT planrows FROM estimate_row('SELECT COUNT(*) ON table WHERE XXX')"

aldoushuxley001 on Dec 11, 2019 [–]

That's actually brilliant.

If you're ever looking for something to write about for a new blog post, I would love to learn more about how you implemented that estimate_count function.

Thanks for the tip in the right direction tho!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact