[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-09-05。"],[],[],null,["# AlloyDB Omni additions to standard PostgreSQL\n\nSelect a documentation version: 16.3.0keyboard_arrow_down\n\n- [Current (16.8.0)](/alloydb/omni/current/docs/additions-to-postgresql)\n- [16.8.0](/alloydb/omni/16.8.0/docs/additions-to-postgresql)\n- [16.3.0](/alloydb/omni/16.3.0/docs/additions-to-postgresql)\n- [15.12.0](/alloydb/omni/15.12.0/docs/additions-to-postgresql)\n- [15.7.1](/alloydb/omni/15.7.1/docs/additions-to-postgresql)\n\n\u003cbr /\u003e\n\nThis page compares [AlloyDB Omni](/alloydb/omni/16.3.0/docs/overview) with standard community [PostgreSQL](https://www.postgresql.org/) in self-managed environments, and it highlights technical, operational, and functionality differences, which are most evident when you deploy AlloyDB Omni with Kubernetes operators. For more information, see the [AlloyDB Omni overview](/alloydb/omni/16.3.0/docs/overview).\n\n\u003cbr /\u003e\n\nA *self-managed database*---which can be on-premises, in other clouds, on\ndeveloper laptops, or on edge locations---means that the user must provision and\nmanage the underlying infrastructure, such as the hardware, operating system\n(OS), and networking.\n\nAlloyDB Omni is a high-performance, operationally efficient\ndatabase that offers the following features:\n\n- Integrated kernel enhancements, such as the columnar engine for analytics and Google's scalable nearest neighbors (ScaNN) index for vector search.\n- Autopilot features such as automatic memory management, adaptive autovacuum, and the index advisor, which simplify database management.\n- Google-provided vendor support, which provides potentially faster bug fixes.\n\nStandard PostgreSQL is a powerful and free open source solution.\nAlloyDB Omni provides commercial support for demanding workloads\nthat benefit from enhanced performance, reduced operational overhead, advanced\nfeatures, and direct vendor support. AlloyDB Omni additions to\nstandard PostgreSQL can outweigh licensing costs.\n\nSummary of AlloyDB Omni additions to PostgreSQL\n-----------------------------------------------\n\nAlloyDB Omni provides the following additions to PostgreSQL:\n\n- **Performance and scalability:** AlloyDB Omni is engineered for significantly higher transactional performance, superior analytical speed using a built-in columnar engine, and better scalability with more CPU and memory resources compared to standard PostgreSQL.\n- **Advanced vector search:** AlloyDB Omni uses Google's ScaNN index for faster, memory-efficient, scalable vector searches compared to standard `pgvector` and hierarchical navigable small world (HNSW).\n- **Automated management (autopilot):** AlloyDB Omni features like adaptive vacuum, automatic memory management, and the index advisor automate complex tuning. These features reduce operational burden and improve database stability.\n- **Faster bug fixes and patches:** With commercial support, Google provides patches and security fixes for AlloyDB Omni directly and potentially faster than the PostgreSQL community release process.\n- **Integrated features:** AlloyDB Omni's built in hybrid transactional and analytical processing (HTAP), advanced vector search, and high availability (HA) reduce the need for external tools or complex configurations compared to standard PostgreSQL.\n- **Cost and licensing:** Standard PostgreSQL is free open source software. AlloyDB Omni is commercial software that you can deploy at no cost for development and non-commercial purposes. However, you need a license to [run AlloyDB Omni in a production environment](/alloydb/omni/16.3.0/docs/run-alloydb-omni-production). Despite the software costs, AlloyDB Omni efficiency capabilities offer potential total cost of ownership (TCO) advantages.\n\nDatabase feature comparison\n---------------------------\n\nThe following table describes the feature differences between\nAlloyDB Omni and PostgreSQL:\n\nWhat's next\n-----------\n\n- Learn about [available AlloyDB Omni download and installation options](/alloydb/omni/16.3.0/docs/available-download-install-options).\n- [Install AlloyDB Omni on any UNIX-based environment that supports container runtimes](/alloydb/omni/16.3.0/docs/quickstart)."]]
