frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Pg_vectorsearch: An index that is faster than pgvector's IVFFlat and HNSW

https://github.com/timescale/pg_vectorsearch
36•jascha_eng•1h ago

Comments

jascha_eng•1h ago
from the accompanying blog post: https://www.tigerdata.com/blog/announcing-pg_vectorsearch-sc...

> TLDR: We are launching pg_vectorsearch, a new open-source PostgreSQL extension that makes vector search dramatically faster and more cost-efficient. Its new PRISM index uses partitioning and compression instead of HNSW's graph-based approach, delivering faster queries with a fraction of the memory and significantly faster index builds. At 100 million vectors, PRISM achieved 6 ms query latency on a machine with 4× less memory than HNSW, with index builds over 20× faster.

Rapzid•46m ago
Does it support filtering though?

Edit: post filtering only

I don't understand how people are efficiently implementing tenant/user/permission scopes with these indexes.

enordstr•20m ago
Multi-column indexes for multi-tenant tables is planned for a future release.
esafak•10m ago
LanceDB supports push down and list/array membership through DataFusion.
EgregiousCube•23m ago
I'm currently running VectorChord and I love it - with a fast backing disk, it's cut my postgres cost in half. Excited to see competition in low-RAM vector index tools. RAMageddon seems to be creating incentives to find more ways to take advantage of how fast modern nvme drives are!
swe_dima•12m ago
Sadly if cloud providers don't offer it on managed postgres then not many people can use it...
esafak•9m ago
Shouldn't you lead with your benchmarks if you're fast? qps and precision/recall, please.

Iosevka is an open-source, sans-serif and slab-serif, monospace font

https://typeof.net/Iosevka/
265•otobrglez•4h ago•96 comments

Pg_vectorsearch: An index that is faster than pgvector's IVFFlat and HNSW

https://github.com/timescale/pg_vectorsearch
39•jascha_eng•1h ago•8 comments

The Aaronson Oracle

https://aaronsonoracle.com/
11•routeroff•50m ago•11 comments

TV4 postpones show after AI agent erases edited material

https://swedenherald.com/article/tv4-postpones-the-challenge-until-2027-after-technical-failure-e...
28•tobr•2h ago•13 comments

Pulsar at ESUG 2026 (new Smalltalk IDE)

https://blog.lorenzano.eu/pulsar-at-esug-2026/
36•mpweiher•2h ago•3 comments

Amazon pushes up prices across the Internet

https://www.not-ship.com/how-amazon-pushes-up-prices-all-across-the-internet/
153•sighborg•3h ago•125 comments

Sound – Bartosz Ciechanowski (2022)

https://ciechanow.ski/sound/
166•dverlaeckt80•2d ago•22 comments

Who Is Planting Backdoors in Ledger Crypto Wallets?

https://www.zetter-zeroday.com/who-is-planting-backdoors-in-ledger-crypto-wallets/
56•hacb•3h ago•56 comments

Show HN: Guitoro, a virtual guitar you strum with your keyboard

https://guitoro.com/
478•talccc•17h ago•127 comments

Show HN: A guided 3D Leonardo da Vinci museum, built in code

https://museumofages.org/w/vinci
23•micstradev•3h ago•8 comments

900-Page Pre-Pantone Guide to Color from 1692 (With Complete High-Res Scan)

https://www.openculture.com/2026/10/a-900-page-pre-pantone-guide-to-color-from-1692.html
195•mdp2021•2d ago•29 comments

Same Job, Two Engines: InnoDB and Iceberg Internals

https://marcpaul.io/logs/same-job-two-engines-innodb-and-iceberg-internals/
34•marcbpaul•23h ago•2 comments

AOSP Source Releases Are So Late Developers Disassemble Libraries to Report Bugs

https://github.com/android/ndk/issues/2260
344•tharen•6h ago•158 comments

Gemini 4 Argon

https://deepmind.google/models/gemini/
1355•737max•21h ago•952 comments

Felix Rieseberg Homepage

https://felixrieseberg.com/
227•rglover•8h ago•87 comments

The United Kingdom generates less electricity per person than in the 1970s

https://ourworldindata.org/data-insights/electricity-generation-per-person-in-the-united-kingdom-...
344•karakoram•21h ago•572 comments

Recreational Programming

https://www.cphiri.dev/presentations/recreational-programming
230•jslakro•14h ago•95 comments

The Origin Story of Kid Pix

http://red-green-blue.com/kid-pix-the-early-years
38•MBCook•1d ago•5 comments

Smart people don't think others are stupid

https://sive.rs/ss
57•andsoitis•1h ago•39 comments

Strafe: A new open-source, E2E Encrypted, and federated alternative to Discord

https://strafe.chat/
61•brydencalaway•9h ago•44 comments

Kcgi – minimal CGI and FastCGI library for C/C++

https://kristaps.bsd.lv/kcgi/
46•Bluestein•1d ago•29 comments

AI Laser Locking for Quantum Computers: How QuEra Automates It

https://www.quera.com/blog-posts/holding-the-light-teaching-an-ai-to-lock-and-tune-our-quantum-co...
13•EvgeniyZh•2h ago•3 comments

MIT class project turns into an FDA-cleared treatment for tremors

https://news.mit.edu/2026/mit-class-project-turns-into-fda-cleared-treatment-for-tremors-1002
229•zdw•1d ago•46 comments

Ledger confirms spy chip implant behind wallet crypto thefts

https://www.bleepingcomputer.com/news/security/ledger-confirms-hardware-wallet-spy-implant-behind...
738•thm•2d ago•464 comments

Show HN: How random are you?

https://lab.specr.net/rigged-draw/
168•vunderba•20h ago•87 comments

Arena Allocators in C

https://eliasebner.com/blog/guides/arena-allocators-in-c/
63•dimonomid•2d ago•24 comments

Maybe a better way to track the release history of a Git repo

https://blog.plover.com/prog/git/history-proposal.html
54•evakhoury•1d ago•11 comments

Redesigning source control at Anthropic

https://www.anthropic.com/engineering/redesigning-source-control
814•Philpax•21h ago•866 comments

AI is a tool and using it well takes skill

https://yyhh.org/blog/2026/10/ai-is-a-tool/
724•layer8•1d ago•562 comments

AlphaNIST

https://alpha-nist.github.io/
82•jasonjmcghee•15h ago•29 comments