“You still get the fundamental Postgres observability (like pg_stat_statements) plus the advanced Google Cloud UI, deeper analytics, and potential machine learning-based tuning suggestions,” Everest’s Ranjan said.
AlloyDB appears to have kept its compatibility with PostgreSQL and many of its features (SQL syntax, concurrency, indexing, stored procedures) but adds a new architecture with the aim of achieving performance enhancements, he said.
“Essentially, Google’s approach has been: Take the Postgres framework, keep it compatible, then accelerate it with a new storage engine and Google’s infrastructure and management tools,” he said.
