When to choose x86-64 vs aarch64

This post details the technical differences between x86-64 and aarch64 CPU architectures in the context of database performance. It explains how hyperthreading (x86) vs. whole cores (aarch64) affects handling of concurrent queries versus heavy single queries. It also discusses the impact of vector register width (AVX2/AVX-512 on x86 vs. 128-bit on aarch64) on specific workloads like full-text search (TIN) and vector similarity search (pgvector). The post highlights that disk files are not portable between architectures, necessitating migration for architecture changes, and provides guidance on choosing between ARM and x86 based on workload characteristics and cost-effectiveness.