News for hackers. Stuff that matters.

A comment on AlloyDB Omni – run AlloyDB anywhere. Parent comment

Re:AlloyDB Omni – run AlloyDB anywhere by GabeWeiss_ on Wednesday March 29, 2023 @02:41PM (#35361409)
It's twice as fast as out of the box PG for most things, and up to 100x faster for reads, depending on what you're doing. So there's that.

Also, from a manageability, on top of the index advisor, there's also vacuum management, so it will figure out when the best time to do the garbage cleanup while minimizing impact on performance.

[ Parent | on HN ]
Re:AlloyDB Omni – run AlloyDB anywhere by dx034 on Thursday March 30, 2023 @05:53AM (#35370269)
The 100x analytics seems due to columnar storage like with TimescaleDB, but how do you get improvements on the other things? Is it really faster on a database with good indexes?
[ Parent | on HN ]
Re:AlloyDB Omni – run AlloyDB anywhere by GabeWeiss_ on Thursday March 30, 2023 @11:05AM (#35373769)
It really is, yes. I can't go into a lot of detail on the "why" because it's not open source and the product team would murder me...but I highly encourage folks to try it for themselves. Nothing else convinced me until I did it for myself. :)
[ Parent | on HN ]