frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Optimizing Top K in Postgres

https://www.paradedb.com/blog/optimizing-top-k
42•philippemnoel•1d ago

Comments

davidelettieri•45m ago
The "But Wait, We Need Filters Too" paragraph mentions "US" filter which is introduced only later on.
GrayShade•14m ago
And footnote 3 is unreferenced.
jmgimeno•3m ago
Maybe I'm wrong, but for this query:

SELECT * FROM benchmark_logs WHERE severity < 3 ORDER BY timestamp DESC LIMIT 10;

this index

CREATE INDEX ON benchmark_logs (severity, timestamp);

cannot be used as proposed: "Postgres can jump directly to the portion of the tree matching severity < 3 and then walk the timestamps in descending order to get the top K rows."

Postgres with this index can walk to a part of the tree with severity < 3, but timestamps are sorted only for the same severity.

Two Years of Emacs Solo

https://www.rahuljuliato.com/posts/emacs-solo-two-years
177•celadevra_•7h ago•42 comments

Optimizing Top K in Postgres

https://www.paradedb.com/blog/optimizing-top-k
42•philippemnoel•1d ago•3 comments

Claude Code, Claude Cowork and Codex #5

https://thezvi.wordpress.com/2026/03/09/claude-code-claude-cowork-and-codex-5/
20•swolpers•2h ago•17 comments

No, it doesn't cost Anthropic $5k per Claude Code user

https://martinalderson.com/posts/no-it-doesnt-cost-anthropic-5k-per-claude-code-user/
120•jnord•7h ago•64 comments

Building a Procedural Hex Map with Wave Function Collapse

https://felixturner.github.io/hex-map-wfc/article/
461•imadr•14h ago•69 comments

Lotus 1-2-3 on the PC with DOS

https://stonetools.ghost.io/lotus123-dos/
32•TMWNN•3d ago•8 comments

Learnings from paying artists royalties for AI-generated art

https://www.kapwing.com/blog/learnings-from-paying-artists-royalties-for-ai-generated-art/
110•jenthoven•4h ago•82 comments

Show HN: Remotely use my guitar tuner

https://realtuner.online/
159•smith-kyle•3d ago•39 comments

JSLinux Now Supports x86_64

https://bellard.org/jslinux/
301•TechTechTech•14h ago•84 comments

Is legal the same as legitimate: AI reimplementation and the erosion of copyleft

https://writings.hongminhee.org/2026/03/legal-vs-legitimate/
423•dahlia•16h ago•460 comments

Show HN: I Was Here – Draw on street view, others can find your drawings

https://washere.live
14•mrktsm__•2h ago•3 comments

macOS Tahoe windows have different corner radiuses

https://lapcatsoftware.com/articles/2026/3/1.html
28•robenkleene•3d ago•10 comments

Darkrealms BBS

http://www.darkrealms.ca/
83•TigerUniversity•3d ago•19 comments

A useless infinite scroll experiment

https://futile.ch/en/
20•dolin_ch•3d ago•11 comments

The “JVG algorithm” only wins on tiny numbers

https://scottaaronson.blog/?p=9615
56•jhalderm•6h ago•26 comments

Show HN: DenchClaw – Local CRM on Top of OpenClaw

https://github.com/DenchHQ/DenchClaw
111•kumar_abhirup•16h ago•96 comments

Launch HN: Terminal Use (YC W26) – Vercel for filesystem-based agents

100•filipbalucha•14h ago•68 comments

DARPA’s new X-76

https://www.darpa.mil/news/2026/darpa-new-x-76-speed-of-jet-freedom-of-helicopter
188•newer_vienna•14h ago•177 comments

RVA23 Ends Speculation's Monopoly in RISC-V CPUs

https://semiwiki.com/ip/risc-v/367094-rva23-ends-speculations-monopoly-in-risc-v-cpus/
14•enz•2d ago•2 comments

OpenAI is walking away from expanding its Stargate data center with Oracle

https://www.cnbc.com/2026/03/09/oracle-is-building-yesterdays-data-centers-with-tomorrows-debt.html
322•spenvo•10h ago•177 comments

An opinionated take on how to do important research that matters

https://nicholas.carlini.com/writing/2026/how-to-win-a-best-paper-award.html
114•mad•14h ago•25 comments

So you want to write an “app” (2025)

https://arcanenibble.github.io/so-you-want-to-write-an-app.html
114•jmusall•10h ago•50 comments

Notes on Baking at the South Pole

https://www.newyorker.com/culture/the-weekend-essay/the-most-beautiful-freezer-in-the-world
52•mitchbob•12h ago•19 comments

Amazon holds engineering meeting following AI-related outages

https://www.ft.com/content/7cab4ec7-4712-4137-b602-119a44f771de
33•petethomas•2h ago•20 comments

Florida judge rules red light camera tickets are unconstitutional

https://cbs12.com/news/local/florida-news-judge-rules-red-light-camera-tickets-unconstitutional
413•1970-01-01•13h ago•530 comments

No leap second will be introduced at the end of June 2026

https://lists.iana.org/hyperkitty/list/tz@iana.org/thread/P6D36VZSZBUSSTSMZKFXKF4T4IXWN23P/
101•speckx•19h ago•107 comments

Windows: Microsoft broke the only thing that mattered

https://www.yankodesign.com/2026/03/08/microsoft-broke-the-only-thing-that-actually-mattered/
71•kjellsbells•2h ago•47 comments

Ireland shuts last coal plant, becomes 15th coal-free country in Europe (2025)

https://www.pv-magazine.com/2025/06/20/ireland-coal-free-ends-coal-power-generation-moneypoint/
932•robin_reala•21h ago•570 comments

Graphing how the 10k* most common English words define each other

https://wyattsell.com/experiments/word-graph/
37•wyattsell•2d ago•11 comments

Flash media longevity testing – 6 years later

https://old.reddit.com/r/DataHoarder/comments/1q6xnun/flash_media_longevity_testing_6_years_later/
151•1970-01-01•1d ago•85 comments