Hacker News: diqi

New comment by diqi in "An Update on Heroku"

diqi — Fri, 06 Feb 2026 22:43:09 +0000

What does this even say?

New comment by diqi in "Ask HN: Share your personal website"

diqi — Wed, 14 Jan 2026 19:35:47 +0000

diqi.dev

AI Turned My Simple Blog into 81 Files and 83 Dependencies

diqi — Wed, 16 Jul 2025 11:04:41 +0000

Article URL: https://diqi.dev/ai-code-generation/

Comments URL: https://news.ycombinator.com/item?id=44580848

Points: 3

# Comments: 0

New comment by diqi in "Show HN: Tesseral – Open-Source Auth"

diqi — Wed, 28 May 2025 17:55:12 +0000

What's so different about auth for B2B?

Create Index Externally: Offloading Pgvector Indexing from Postgres

diqi — Wed, 02 Oct 2024 14:41:53 +0000

Article URL: https://lantern.dev/blog/pgvector-external-indexing

Comments URL: https://news.ycombinator.com/item?id=41721124

Points: 5

# Comments: 0

New comment by diqi in "Show HN: View and search Postgres mailing lists"

diqi — Thu, 19 Sep 2024 13:08:47 +0000

Thank you!

It’s just naively showing the first 20 results at the moment from FTS or vector search.

Thanks for the feedback! I’ll make some edits.

You can actually search all the channels at once if you “deselect” the channel in the left! But I know that can be improved as well

Show HN: View and search Postgres mailing lists

diqi — Thu, 19 Sep 2024 06:52:02 +0000

I built a site to browse the Postgres mailing list archives. It supports search using full text search from Postgres + vector search with the Lantern Postgres extension.

I've been using it for testing but cleaned it up a bit to share. :) Hopefully it's interesting to someone.

Comments URL: https://news.ycombinator.com/item?id=41589264

Points: 2

# Comments: 2

Understanding Pgvector's HNSW Index Storage in Postgres

diqi — Thu, 22 Aug 2024 20:42:16 +0000

Article URL: https://lantern.dev/blog/pgvector-storage

Comments URL: https://news.ycombinator.com/item?id=41324231

Points: 3

# Comments: 0

Show HN: Dynamically loaded extensions in Postgres in the browser

diqi — Fri, 26 Jul 2024 15:28:04 +0000

Article URL: https://lantern.dev/blog/pglite-lantern

Comments URL: https://news.ycombinator.com/item?id=41079426

Points: 2

# Comments: 0

Postgres vs. Pinecone

diqi — Fri, 19 Jul 2024 15:44:46 +0000

Article URL: https://lantern.dev/blog/postgres-vs-pinecone

Comments URL: https://news.ycombinator.com/item?id=41007624

Points: 119

# Comments: 17

New comment by diqi in "Ask HN: Why aren't there more hearing aid startups?"

diqi — Tue, 16 Jan 2024 04:03:41 +0000

Auricle (W21) and AudioFocus (S19) were two YC startups around hearing, I'm not sure what the status of them is though.

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Fri, 05 Jan 2024 00:05:15 +0000

I added an edited note to the bottom of the blog post.

The original post and the experiments were created before pgvector 0.5.1 was out, and we had not realized there was significant work to optimize index creation time in the latest pgvector release.

We reran pgvector benchmarks with pgvector 0.5.1. Now pgvector index creation is on par or 10% faster than lantern on a single core. Lantern still allows 30x faster index creation by leveraging additional cores.

Wiki Pgvector - 36m Lantern - 43m Lantern external indexing (32 CPU): 2m 15s

Sift Pgvector - 12m30s Lantern - 7m Lantern external indexing (32 CPU): 25s

The DB parameters for the above results (both Lantern and pgvector): shared_buffers=12GB maintenance_work_mem=5GB work_mem=2GB

The DB parameters for the previous results were the defaults for both Lantern and pgvector.

Benchmarking was done using psql timing and used a 32CPU/64GB RAM machine (Linode Dedicated 64).

Feel free to reach out if you need anything for benchmarks.

New comment by diqi in "Launch HN: Rosebud (YC S19) – Turn game descriptions into browser games"

diqi — Thu, 04 Jan 2024 20:14:35 +0000

> Next up: an AI that can watch a deceptive mobile game ad and actually create the game that they're falsely advertising!

Would love if it could create Age of Origins, I always like watching the ads

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Wed, 03 Jan 2024 06:08:25 +0000

We used 0.5.0 for these

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Tue, 02 Jan 2024 23:40:38 +0000

Hi, sorry that you didn't have a good experience with Lantern before. We first posted in HN about 3 months ago - Things should be better now, please let us know if you have any issues.

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Tue, 02 Jan 2024 22:14:44 +0000

We haven't benchmarked against 0.5.2 yet so I can't share exact numbers. We will benchmark it once it is released.

We think our approach will still significantly outperform pgvector because it does less on your production database.

We generate the index remotely, on a compute-optimized machine, and only use your production database for index copy.

Parallel pgvector would have to use your production database resources to run the compute-intensive HNSW index creation workload.

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Tue, 02 Jan 2024 21:23:57 +0000

Ah, thank you for noticing! We actually have typo in the error message. It actually should be the operator instead of <->.

There's some context on the operator here: https://github.com/lanterndata/lantern?tab=readme-ov-file#a-...

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Tue, 02 Jan 2024 21:20:32 +0000

Try YCW24! :)

New comment by diqi in "90x Faster Than Pgvector – Lantern's HNSW Index Creation Time"

diqi — Tue, 02 Jan 2024 20:51:38 +0000

Yes it is WAL protected: the advantage of external indexing is that the HNSW graph is being constructed externally on multiple cores instead on a single core inside the Postgres process. But eventually the graph is being parsed and processed inside Postgres with all the necessary WAL logs for blocks.

90x Faster Than Pgvector – Lantern's HNSW Index Creation Time

diqi — Tue, 02 Jan 2024 18:21:03 +0000

Article URL: https://lantern.dev/blog/hnsw-index-creation

Comments URL: https://news.ycombinator.com/item?id=38844945

Points: 109

# Comments: 36