Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by drdrek on Thursday May 08, 2025 @03:52AM (#43924046)

Postgres is such a cool project, I have so much respect for its maintainers and community! For me its the second most impactful OSS project in the business tech world behind Linux itself. A real public good to be cherished and praised.

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by freilanzer on Thursday May 08, 2025 @05:20AM (#43924480)

I recently started a ML project using text data and the choice was between MySQL and Postgres. Having looked at the respective features and pros and cons, the choice was immediately obvious. Also, with pgvector and https://postgresml.com available, the choice for Postgres was even easier.

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by cpursley on Thursday May 08, 2025 @07:15AM (#43925064)

Postgres is Enough: https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f...

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by powerbook5300CS on Thursday May 08, 2025 @07:43AM (#43925191)

Why not MongoDB?

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by IgorPartola on Thursday May 08, 2025 @08:17AM (#43925400)

I guess they didn’t need anything web scale.

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by ricw on Thursday May 08, 2025 @08:21AM (#43925425)

The question should be the other way around: why mongodb? It’s not ACID compliant so has major down sides…

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by okeuro49 on Thursday May 08, 2025 @10:43AM (#43926519)

According to mongodb it is acid compliant.

https://www.mongodb.com/resources/products/capabilities/acid...

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by belter on Thursday May 08, 2025 @09:48AM (#43926081)

Because it's web scale...

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by belter on Thursday May 08, 2025 @09:46AM (#43926060)

You can get no better recommendation, that a phrase I once heard at a presentation by Richard Hipp primary author of SQLite. As he was explaining how he analyzed new features and design decisions he says some of his guidance is: "What would Postgres do?"

[ Parent | on HN ]