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

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 ]