AlloyDB for PostgreSQL documentation
AlloyDB is a fully-managed, PostgreSQL-compatible database for demanding
transactional workloads. It provides enterprise-grade performance and availability
while maintaining 100% compatibility with open-source PostgreSQL.
Not sure what database option is right for you? Learn more about
our database services.
Learn more about AlloyDB.
Start your proof of concept with $300 in free credit
-
Get access to Gemini 2.0 Flash Thinking
-
Free monthly usage of popular products, including AI APIs and BigQuery
-
No automatic charges, no commitment
Keep exploring with 20+ always-free products
Access 20+ free products for common use cases, including AI APIs, VMs, data warehouses,
and more.
Training
Training and tutorials
AlloyDB AI Embedding lab
Get hands-on practice with creating and using vector embeddings using AlloyDB. This codelab guides you through setting up an AlloyDB cluster, integrating it with Vertex AI, and then applying a generative model to data queries.
107 minutes
Introductory
Free
Training
Training and tutorials
Semantic search with AlloyDB PG_Vector
This lab walks you through building a semantic search web application for searching through movie plot summaries using AlloyDB vector search to find movies and similar movies. Signing in to Google Cloud Qwiklabs is required to access this lab.
135 minutes
Introductory
Free
Use case
Use cases
Whitepaper: ScaNN for AlloyDB for PostgreSQL
Explains how ScaNN for AlloyDB for PostgreSQL achieves faster performance and improves memory footprint.
ScaNN
vector search
vector embeddings
vector indexing
Use case
Use cases
Best practices for tuning ScaNN indexes
Provides recommendations about how to tune index parameters for optimal balance between recall and QPS.
ScaNN
optimization
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-26 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-26 UTC."],[[["\u003cp\u003eAlloyDB for PostgreSQL is a fully-managed, PostgreSQL-compatible database designed for demanding transactional workloads, providing enterprise-grade performance and availability.\u003c/p\u003e\n"],["\u003cp\u003eAlloyDB offers 100% compatibility with open-source PostgreSQL, allowing seamless integration with existing PostgreSQL tools and applications.\u003c/p\u003e\n"],["\u003cp\u003eAlloyDB AI enables building generative AI applications, performing vector searches, and integrating with Vertex AI, expanding the database's capabilities beyond traditional workloads.\u003c/p\u003e\n"],["\u003cp\u003eComprehensive resources, including quickstarts, guides, reference materials, and training labs, are available to help users get started and optimize their use of AlloyDB.\u003c/p\u003e\n"],["\u003cp\u003eUsers can leverage features like the columnar engine to accelerate queries and Query Insights to analyze performance, improving the overall efficiency and effectiveness of their database operations.\u003c/p\u003e\n"]]],[],null,["AlloyDB for PostgreSQL documentation \n[Read product documentation](/alloydb/docs/overview) AlloyDB is a fully-managed, PostgreSQL-compatible database for demanding\ntransactional workloads. It provides enterprise-grade performance and availability\nwhile maintaining 100% compatibility with open-source PostgreSQL.\n\nNot sure what database option is right for you? Learn more about\nour [database services](/products/databases).\n\n[Learn more](/alloydb/docs/overview) about AlloyDB.\n[Get started for free](https://console.cloud.google.com/freetrial) \n\nStart your proof of concept with $300 in free credit\n\n- Get access to Gemini 2.0 Flash Thinking\n- Free monthly usage of popular products, including AI APIs and BigQuery\n- No automatic charges, no commitment \n[View free product offers](/free/docs/free-cloud-features#free-tier) \n\nKeep exploring with 20+ always-free products\n\n\nAccess 20+ free products for common use cases, including AI APIs, VMs, data warehouses,\nand more.\n\nDocumentation resources \nFind quickstarts and guides, review key references, and get help with common issues. \nfollow_the_signs\n\nGet started\n\n-\n\n [AlloyDB overview](/alloydb/docs/overview)\n\n-\n\n [AlloyDB AI tutorials, codelabs, and notebooks](/alloydb/docs/ai/alloydb-ai-use-cases)\n\n-\n\n [Create and connect to a database](/alloydb/docs/quickstart/create-and-connect)\n\n-\n\n [Connect from Google Kubernetes Engine (GKE) to AlloyDB](/alloydb/docs/quickstart/integrate-kubernetes)\n\n-\n\n [Grant AlloyDB access to other users](/alloydb/docs/user-grant-access)\n\n-\n\n [Perform a vector search](/alloydb/docs/ai/perform-vector-search)\n\n-\n\n [Integrate AlloyDB with Vertex AI](/alloydb/docs/ai/configure-vertex-ai)\n\nformat_list_numbered\n\nGuides\n\n-\n\n [Accelerate queries using the columnar engine](/alloydb/docs/columnar-engine/about)\n\n-\n\n [Analyze performance using Query Insights](/alloydb/docs/query-insights-overview)\n\n-\n\n [Build generative AI applications using AlloyDB AI](/alloydb/docs/ai)\n\n-\n\n [Connect a psql client](/alloydb/docs/connect-psql)\n\n-\n\n [Connect securely using the Auth proxy](/alloydb/docs/auth-proxy/overview)\n\n-\n\n [Create a read pool instance](/alloydb/docs/instance-read-pool-create)\n\n-\n\n [Scale an instance](/alloydb/docs/instance-read-pool-scale)\n\n-\n\n [Configure backup plans](/alloydb/docs/backup/configure)\n\ngroup_work\n\nReference \\& Resources\n\n-\n\n [gcloud CLI reference](/sdk/gcloud/reference/beta/alloydb)\n\n-\n\n [IAM roles and permissions](/alloydb/docs/reference/iam-roles-permissions)\n\n-\n\n [Locations](/alloydb/docs/locations)\n\n-\n\n [Pricing](/alloydb/pricing)\n\n-\n\n [Quotas and limits](/alloydb/quotas)\n\n-\n\n [Release notes](/alloydb/docs/release-notes)\n\n-\n\n [REST API reference](/alloydb/docs/reference/rest)\n\n-\n\n [Supported database flags](/alloydb/docs/reference/database-flags)\n\nRelated resources Training and tutorials \nUse cases \nExplore self-paced training, use cases, reference architectures, and code samples with examples of how to use and connect Google Cloud services. Training \nTraining and tutorials\n\nAlloyDB AI Embedding lab\n\n\nGet hands-on practice with creating and using vector embeddings using AlloyDB. This codelab guides you through setting up an AlloyDB cluster, integrating it with Vertex AI, and then applying a generative model to data queries.\n\n\n107 minutes Introductory Free\n\n\u003cbr /\u003e\n\n[Learn more](https://codelabs.developers.google.com/codelabs/alloydb-ai-embedding) \nTraining \nTraining and tutorials\n\nSemantic search with AlloyDB PG_Vector\n\n\nThis lab walks you through building a semantic search web application for searching through movie plot summaries using AlloyDB vector search to find movies and similar movies. Signing in to Google Cloud Qwiklabs is required to access this lab.\n\n\n135 minutes Introductory Free\n\n\u003cbr /\u003e\n\n[Learn more](https://explore.qwiklabs.com/focuses/7136?parent=catalog) \nUse case \nUse cases\n\nWhitepaper: ScaNN for AlloyDB for PostgreSQL\n\n\nExplains how ScaNN for AlloyDB for PostgreSQL achieves faster performance and improves memory footprint.\n\nScaNN vector search vector embeddings vector indexing\n\n\u003cbr /\u003e\n\n[Learn more](https://services.google.com/fh/files/misc/scann_for_alloydb_whitepaper.pdf) \nUse case \nUse cases\n\nBest practices for tuning ScaNN indexes\n\n\nProvides recommendations about how to tune index parameters for optimal balance between recall and QPS.\n\nScaNN optimization\n\n\u003cbr /\u003e\n\n[Learn more](/alloydb/docs/ai/best-practices-tuning-scann)\n\nRelated videos"]]