Readit News logoReadit News
jmgimeno commented on Optimizing Top K in Postgres   paradedb.com/blog/optimiz... · Posted by u/philippemnoel
jmgimeno · 2 days 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.

jmgimeno commented on Sbt and the Miners of the Wild West   eed3si9n.com/sbt-and-the-... · Posted by u/jmgimeno
jmgimeno · a month ago
A post discusses how Gittensor, a Bittensor subnetwork, uses cryptocurrency to incentivize open-source software contributions, attracting both senior and junior developers. The author observes that while this model promises a decentralized workforce, the influx of contributions, particularly from junior developers requiring significant review, may increase the maintenance burden on projects like sbt and raises questions about the sustainability of quality without overwhelming maintainers.
jmgimeno commented on Most Influential Papers in Computer Science History   terriblesoftware.org/2025... · Posted by u/jonbaer
jmgimeno · a year ago
"The UNIX TimeSharing System", by Dennis M. Ritchie and Ken Thompson.
jmgimeno commented on ZIO in 2025   ziverge.com/post/zio-in-2... · Posted by u/jmgimeno
jmgimeno · a year ago
ZIO plans to streamline its ecosystem in 2025 by integrating core projects and focusing on enterprise stability.
jmgimeno commented on Ten years of improvements in PostgreSQL's optimizer   rmarcus.info/blog/2024/04... · Posted by u/samaysharma
abhishekjha · 2 years ago
Is there a more general reading for software engineers?

Seems like jumping right into the code can be a bit overwhelming if you have no background on the topic.

jmgimeno · 2 years ago
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya and Boris Novikov Anna Bailliekova, published by Apress in 2021.
jmgimeno commented on Scala Resurrection   degoes.net/articles/scala... · Posted by u/jmgimeno
jmgimeno · 3 years ago
In this post, John de Goes discusses the issues standing in the way of Scala’s growth in industry, and share his thoughts about how we can all help.
jmgimeno commented on Ask HN: Is programming a “young person's game”?    · Posted by u/shetill
laputan_machine · 3 years ago
--I don't think progressing in mathematics is only for young people, fields medal winners are typically in their late 30s, early 40s. I guess whether or not that is "young" depends on you.-- Nope. See child comment.

Anecdotally, my best experiences have been with older programmers. I worked with a guy in his 60s who had some absolutely incredible personal stories to tell (he hitchhiked from Europe to India in the 70s...) but also a wealth of previous knowledge from his decades in the industry. He'd seen a lot, but still had an attitude to learninng (he was writing node.js, ES2020, all the modern gubbins, promises, maps, etc).

I think it's more to do with you as a person. Are you willing to keep studying and learning for the rest of your career? Even if you're not, there will probably be a slew of jobs that are fine for someone who has already "peaked".

TL;DR: I don't believe so

jmgimeno · 3 years ago
> don't think progressing in mathematics is only for young people, fields medal winners are typically in their late 30s, early 40s.

Fields medal is for mathematicians under 40 years of age.

u/jmgimeno

KarmaCake day29April 14, 2012View Original