Google has announced a preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run on premises, or in the cloud. The developers say AlloyDB Omni offers similar benefits to AlloyDB, including high performance, PostgreSQL-compatibility, and Google Cloud support.

AlloyDB was developed by taking the PostgreSQL API and extending it with Google's own machine learning, AI and storage features. It automates administrative tasks such as backups, replication, patching, and capacity management and uses adaptive algorithms and machine learning for PostgreSQL vacuum management, storage and memory management, data tiering, and analytics acceleration.

AlloyDB Omni is based on the same engine as the cloud-based AlloyDB service, and Google says in its tests AlloyDB Omni is more than two times faster than standard PostgreSQL for transactional workloads, and delivers up to one hundred times faster analytical queries than standard PostgreSQL.

The AlloyDB team says that like the AlloyDB managed service, Omni provides improved transactional performance compared to standard PostgreSQL, accelerated analytical processing, automatic vacuum and memory management, and an index advisor that helps optimize frequently run queries.

The index advisor is designed to take the guesswork out of tuning query performance. It does this by analyzing the different parts of a query including subqueries, joins, and filters. It periodically analyzes the database workload, identifies queries that can benefit from indexes, and recommends new indexes that can increase query performance.

AlloyDB Omni also includes the AlloyDB columnar engine, which keeps frequently queried data in an in-memory columnar format for faster scans, joins, and aggregations.

Omni uses machine learning to automatically organize data between row-based and columnar formats, converting the data when needed, and to choose between columnar and row-based execution plans.

There's a free developer edition of AlloyDB Omni that's available for download now.

 

More Information

AlloyDB

AlloyDB Omni

Related Articles

AlloyDB For PostgreSQL Now Generally Available

Google Announces AlloyDB To Free Users From Legacy Databases

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info