$CLOUD_LONG is the modern $PG data platform for all your applications. It enhances $PG to handle time series, events, real-time analytics, and vector search—all in a single database alongside transactional workloads.
You get one system that handles live data ingestion, late and out-of-order updates, and low latency queries, with the performance, reliability, and scalability your app needs. Ideal for IoT, crypto, finance, SaaS, and a myriad other domains, $CLOUD_LONG allows you to build data-heavy, mission-critical apps while retaining the familiarity and reliability of $PG.
A $SERVICE_LONG is a single optimised $PG instance extended with innovations in the database engine and cloud infrastructure to deliver speed without compromise. A $SERVICE_LONG instance is 10-1000x faster at scale! A $SERVICE_SHORT is ideal for applications requiring strong data consistency, complex relationships, and advanced querying capabilities. Get ACID compliance, extensive SQL support, JSON handling, and extensibility through custom functions, data types, and extensions. To the $PG you know and love, $CLOUD_LONG adds the following capabilities:
- Real-time analytics: store and query time-series data at scale for real-time analytics and other use cases. Get faster time-based queries with $HYPERTABLEs, $CAGGs, and columnar storage. Save money by compressing data into the $COLUMNSTORE and deleting old data with automated policies.
- AI-focused: build AI applications from start to scale. Get fast and accurate similarity search with the pgvector and pgvectorscale extensions. Create vector embeddings and perform LLM reasoning on your data with the pgai extension.
- Hybrid applications: get a full set of tools to develop applications that combine time-based data and AI.
All $SERVICE_LONGs include the tooling you expect for production and developer environments: live migration, automatic backups and PITR, high availability, $READ_REPLICAs, data forking, connection pooling, usage-based storage, secure in-$CONSOLE SQL editing, $SERVICE_SHORT metrics and insights, streamlined maintenance, and much more. $CLOUD_LONG continuously monitors your $SERVICE_SHORTs and prevents common $PG out-of-memory crashes.