News for hackers. Stuff that matters.
Re:Show HN: Prisma Postgres. Runs on bare metal and unikernels by endorphine on Sunday November 03, 2024 @05:12AM (#42032207)
What makes its connection pool "advanced"?
Re:Show HN: Prisma Postgres. Runs on bare metal and unikernels by gniting on Sunday November 03, 2024 @05:26AM (#42032261)
- autoscaling - connection pool size limits - query limits - multi-region support out of the box

more here: https://www.prisma.io/docs/accelerate/connection-pooling

also recommend trying out the Accelerate speed test to get a "feel for it": https://accelerate-speed-test.prisma.io/

Re:Show HN: Prisma Postgres. Runs on bare metal and unikernels by IceDane on Sunday November 03, 2024 @10:23AM (#42033562)
I'm wondering big the prisma overhead is here. I know that historically, prisma has been very slow - the sidecar process and the generic protocol and database agnosticism come with a steep cost, and the numbers shown in the benchmark both seem rather low to me. 4x the performance of "very slow" isn't super impressive.. but of course, I can't verify this right now since I don't have access to machine where I can duplicate this and run some raw postgres queries to compare.
Re:Show HN: Prisma Postgres. Runs on bare metal and unikernels by eampiart on Sunday November 03, 2024 @11:10AM (#42033839)
The global caching gets even more interesting and beneficial when the end users are all over the globe, and you're caching queries that simply take longer to execute on the db. You'll save time both on latency and compute that way. For example, everything running on the speedtest is through a single internal Accelerate project so we have some data: the overall average is 58x faster, with 779.53 ms served from origin and 13.28 ms served from cache.

Nonetheless, we absolutely have room for improvement on the ORM in terms of performance, and are working on those as well!