Article complete

Google introduces PostgreSQL database AlloyDB

Google informs that AlloyDB for PostgreSQL was built on the principle of disaggregation of compute and storage and designed to leverage disaggregation at every layer of the stack.

A woman and child are reaching toward a colorful Google logo against a blue grid background.

Key takeaways

  • AlloyDB for PostgreSQL is a fully-managed database designed for enterprise-grade workloads.
  • The database leverages disaggregation of compute and storage across its architecture.
  • Performance tests indicate AlloyDB significantly outperforms standard PostgreSQL in both transactional and analytical queries.
  • The system includes a low-latency log storage service and a log processing service for efficiency.
  • AlloyDB's design ensures durability and scalability through sharded regional block storage.

Takeaways drafted with AI from the article text.

At the Google I/O event, Google introduced AlloyDB for PostgreSQL, a fully-managed, PostgreSQL-compatible database for demanding enterprise-grade transactional and analytical workloads. Google claimed that in its performance tests, AlloyDB gave "more than 4x faster on transactional workloads, and up to 100x faster analytical queries than standard PostgreSQL, all with simple, predictable pricing."

Google informs in a blog post that AlloyDB for PostgreSQL was built on the principle of disaggregation of compute and storage and designed to leverage disaggregation at every layer of the stack.

Design

It is a distributed system and has three parts: 

  • A low-latency, regional log storage service catering to very fast write-ahead log writing.
  • A log processing service that processes these write-ahead log records and produces "materialised" database blocks.
  • Failure-tolerant, sharded, regional block storage for durability even in case of zonal storage failures.

Image: Google

Published

Spotted an error? Tell our editors. Read our editorial standards and corrections.