Back to feed
GCP·AlloyDB for PostgreSQLannouncement·
AI Insights

The following AlloyDB AI functions are available in Preview:


The following AlloyDB AI functions are available in Preview:

• You can now use AI function acceleration and the new AI Function Apply node to run faster queries with AI functions. This feature optimizes the execution of SQL queries that use the ai.if and ai.rank functions in PostgreSQL 17. For more information, see Accelerate performance for queries with AI functions. • You can now use optimized AI functions to accelerate your AI queries while reducing operational costs. By training a smaller, faster proxy model on a sample of your data, AlloyDB can process most AI queries locally and only fall back to a remote LLM when necessary. For more information, see Accelerate queries using optimized functions. • You can now use the sentiment analysis and summarization functions. These functions let you process and analyze unstructured data directly in your database:

ai.analyze_sentiment: classifies the emotional tone of text as positive, negative, or neutral, helping you analyze real-time customer feedback from thousands of raw, unstructured product reviews. • ai.summarize: condenses lengthy text into its essential information. Use this to extract key decisions and action items from sources like meeting transcripts or technical documentation. • ai.agg_summarize: an aggregate function that processes multiple rows in a column to generate a single, unified summary for a group. For instance, you can summarize all reviews for a specific seller using a GROUP BY clause.

For more information, see Evaluate sentiment and Summarize content.