PostgreSQL on ARM-Based AWS EC2 Instances

Re:PostgreSQL on ARM-Based AWS EC2 Instances by lfittl on Friday January 22, 2021 @03:31PM (#25876005)

When using pre-built Postgres packages on modern ARM platforms, like the author of this post is, double check that the Postgres binaries are actually using the ARMv8.2 assembly instructions.

This can make a significant performance difference, and at least for the RPM-based official Postgres packages this is a problem: https://www.postgresql.org/message-id/CACN56%2BP1astF5zvocrT...

[ Parent | on HN ]

Re:PostgreSQL on ARM-Based AWS EC2 Instances by Abishek_Muthian on Saturday January 23, 2021 @02:05AM (#25880325)

Thanks, that might explain something I'm wondering for a while now.

I was running Postgres on a 2-core/2GB ARMv8 scaleway instance and had to migrate to AWS T2 micro (1-core/1GB)x86 when scaleway pulled the plug on ARM servers.

I expected performance decrease due to obvious reduction in HW specs, but on the contrary the application is much snappier. I don't have PG bench figures, but I can clearly notice performance improvements (discounting the network variables).

[ Parent | on HN ]

Re:PostgreSQL on ARM-Based AWS EC2 Instances by arronax on Saturday January 23, 2021 @03:41AM (#25880704)

One of co-authors here. Yes, I expected that to be a huge problem, but, at least for Ubuntu (or, I guess, deb packages), it seemingly wasn't. Which is a pretty big deal, as I doubt a lot of people compile their own PostgreSQL. Trying to push PG on ARM platform to a limit would be an interesting exercise, though, and could necessitate a custom build.

[ Parent | on HN ]