frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Indexing 100M vectors in 20 minutes on PostgreSQL with 12GB RAM

https://blog.vectorchord.ai/how-we-made-100m-vector-indexing-in-20-minutes-possible-on-postgresql
63•gaocegege•5d ago

Comments

duckbot3000•4d ago
Kinda makes you wonder why you need cloud for anything besides remote encrypted backups if you can run all that on 12GB
setr•4d ago
Because getting any hardware out of infra-team on premise is utterly miserable, across the board.
lelanthran•1h ago
That's not the only alternative.

Rent your VPS and add in extra volumes for like $10 per 100GB.

riku_iki•3d ago
what about failover story if server dies? PG failover setup is complicated, and cloud infra handles this for you.
positron26•1h ago
Do we mean managed or PG on K8s like CNPG? In all cases, I use the infra to simplify things like having disk redundancy and failover nodes, not because 12GB is interesting.
riku_iki•1h ago
Primary managed PG, since you still need setup/maintenance/monitoring on your K8S own solution.
logifail•7m ago
(Genuine question) What's your current plan for when your cloud provider goes offline? Do you have a failover story, or it a case of "wait for them to come back online"?
nwellinghoff•4d ago
Too bad aws does not support any of these other vector extensions in managed rds.
ayende•1h ago
That suffer from a serious issue

You must have the data upfront, you cannot build this in an incremental fashion

There is also bo mention on how this would handle updates, and from the description, even if updates are possible, this will degrade over time, requiring new indexing batch

esafak•51m ago
How does it compare with paradedb and lancedb?

I tried Gleam for Advent of Code

https://blog.tymscar.com/posts/gleamaoc2025/
89•tymscar•2h ago•37 comments

Fast, Memory-Efficient Hash Table in Java: Borrowing the Best Ideas

https://bluuewhale.github.io/posts/building-a-fast-and-memory-efficient-hash-table-in-java-by-bor...
39•birdculture•1h ago•0 comments

What is the nicest thing a stranger has ever done for you?

https://louplummer.lol/nice-stranger/
148•speckx•1d ago•91 comments

Analysis finds anytime electricity from solar available as battery costs plummet

https://pv-magazine-usa.com/2025/12/12/analysis-finds-anytime-electricity-from-solar-available-as...
43•Matrixik•1h ago•31 comments

Cryptids

https://wiki.bbchallenge.org/wiki/Cryptids
47•frozenseven•1w ago•4 comments

SSE sucks for transporting LLM tokens

https://zknill.io/posts/sse-sucks-for-transporting-llm-tokens/
7•zknill•4d ago•2 comments

Java FFM zero-copy transport using io_uring

https://www.mvp.express/
76•mands•6d ago•27 comments

Z8086: Rebuilding the 8086 from Original Microcode

https://nand2mario.github.io/posts/2025/z8086/
21•nand2mario•3h ago•4 comments

macOS 26.2 enables fast AI clusters with RDMA over Thunderbolt

https://developer.apple.com/documentation/macos-release-notes/macos-26_2-release-notes#RDMA-over-...
506•guiand•22h ago•259 comments

EasyPost (YC S13) Is Hiring

https://www.easypost.com/careers
1•jstreebin•1h ago

Useful patterns for building HTML tools

https://simonwillison.net/2025/Dec/10/html-tools/
127•simonw•2d ago•42 comments

Photographer built a medium-format rangefinder, and so can you

https://petapixel.com/2025/12/06/this-photographer-built-an-awesome-medium-format-rangefinder-and...
123•shinryuu•6d ago•27 comments

Apple has locked my Apple ID, and I have no recourse. A plea for help

https://hey.paris/posts/appleid/
1339•parisidau•14h ago•764 comments

Go Proposal: Secret Mode

https://antonz.org/accepted/runtime-secret/
83•enz•3d ago•22 comments

How exchanges turn order books into distributed logs

https://quant.engineering/exchange-order-book-distributed-logs.html
97•rundef•5d ago•50 comments

Researchers seeking better measures of cognitive fatigue

https://www.nature.com/articles/d41586-025-03974-w
66•bikenaga•2d ago•11 comments

A Lisp Interpreter Implemented in Conway's Game of Life (2021)

https://woodrush.github.io/blog/posts/2022-01-12-lisp-in-life.html
65•pabs3•15h ago•2 comments

Indexing 100M vectors in 20 minutes on PostgreSQL with 12GB RAM

https://blog.vectorchord.ai/how-we-made-100m-vector-indexing-in-20-minutes-possible-on-postgresql
63•gaocegege•5d ago•10 comments

Show HN: LinkedQL – Live Queries over Postgres, MySQL, MariaDB

https://github.com/linked-db/linked-ql
16•phrasecode•5d ago•6 comments

A 'toaster with a lens': The story behind the first handheld digital camera

https://www.bbc.com/future/article/20251205-how-the-handheld-digital-camera-was-born
62•selvan•5d ago•29 comments

GNU Unifont

https://unifoundry.com/unifont/index.html
301•remywang•22h ago•70 comments

Computer Animator and Amiga fanatic Dick Van Dyke turns 100

187•ggm•10h ago•49 comments

Rats Play DOOM

https://ratsplaydoom.com/
366•ano-ther•22h ago•136 comments

Will West Coast Jazz Get Some Respect?

https://www.honest-broker.com/p/will-west-coast-jazz-finally-get
39•paulpauper•6d ago•18 comments

Dynamic Pong Wars

https://markodenic.tech/dynamic-pong-wars/
16•rendall•1w ago•2 comments

Beautiful Abelian Sandpiles

https://eavan.blog/posts/beautiful-sandpiles.html
113•eavan0•3d ago•17 comments

OpenAI are quietly adopting skills, now available in ChatGPT and Codex CLI

https://simonwillison.net/2025/Dec/12/openai-skills/
514•simonw•19h ago•297 comments

Show HN: I made a spreadsheet where formulas also update backwards

https://victorpoughon.github.io/bidicalc/
208•fouronnes3•2d ago•98 comments

Show HN: Tiny VM sandbox in C with apps in Rust, C and Zig

https://github.com/ringtailsoftware/uvm32
177•trj•20h ago•11 comments

Show HN: I audited 500 K8s pods. Java wastes ~48% RAM, Go ~18%

https://github.com/WozzHQ/wozz
6•wozzio•3h ago•4 comments