Content

Basics

Understand the basic architecture of PostgreSQL Flex, learn about key features and how to use the database effectively.

Getting started

Create your first PostgreSQL Flex instance. Follow the guides to build a working setup and connect in minutes.

How-tos

Manage instances, users, and backups. Connect with various tools such as Cloud Foundry and Terraform.

Reference

Find API documentation, CLI commands, performance metrics and an overview of project roles and permissions.

FAQ

Quickly find answers to frequently asked questions about PostgreSQL Flex.

Release notes

Discover what's new in PostgreSQL Flex, including added features, bug fixes and deprecation notices.

Features

• ACID compliance & data integrity: Ensure your data remains consistent and reliable with full ACID (Atomicity, Consistency, Isolation, Durability) transaction support. Perfect for applications where data accuracy and integrity are non-negotiable.
• Advanced SQL support: leverage sophisticated SQL features including window functions, CTEs (Common Table Expressions), JSON operators, and custom functions. PostgreSQL’s SQL implementation goes beyond standard SQL with powerful extensions.
• Extensible type system: Work with rich data types including arrays, JSON/JSONB, geometric types, network addresses, and UUID. Create custom types and operators to match your specific domain requirements.
• Flexible indexing options: Optimize query performance with advanced indexing strategies: B-tree, Hash, GiST, SP-GiST, GIN, and BRIN indexes. Support for partial indexes, expression indexes, and full-text search capabilities.
• High performance concurrency: Handle thousands of concurrent connections efficiently with Multi-Version Concurrency Control (MVCC). Readers never block writers, ensuring consistent performance under heavy load.

Use cases

PostgreSQL Flex offers the reliability and advanced features you need to handle complex data requirements. Here are key use cases where it truly shines:

• Financial & transaction systems: Build robust financial applications with strict ACID compliance. Handle complex transactions, maintain audit trails, and ensure data consistency for banking, payment processing, and accounting systems.
• Data warehousing & business intelligence: Create sophisticated analytical systems with advanced SQL features. Use window functions, materialized views, and complex joins to build comprehensive reporting and business intelligence platforms.
• Geospatial applications: power location-based services with PostGIS extension. Store and query geographic data, perform spatial analysis, and build mapping applications with advanced geospatial capabilities.
• Multi-tenant SaaS applications: Design scalable SaaS platforms with row-level security and schema isolation. PostgreSQL’s advanced permission system enables secure multi-tenant architectures with data separation.
• Time-series & analytics workloads: Handle high-volume time-series data with specialized extensions. Monitor system metrics, track user behavior, and analyze temporal data patterns with optimized storage and query performance.

Latest updates

• feature

  STACKIT PostgreSQL Flex – New disk size is available

  May 30, 2025

  We would like to inform you that it is now possible to order STACKIT PostgreSQL Flex instances with the size of 4 TB. Before, the maximum size of one instance was 2 TB. Our Help Center is always at your disposal if you have any questions.

• deprecated

  STACKIT PostgreSQL Flex – Version 13 is getting deprecated

  May 1, 2025

  We would like to inform you that the STACKIT PostgreSQL Flex Version 13 will reach the end of support on December 01, 2025. All existing services with PostgreSQL Version 13 must be updated to PostgreSQL Version 14 or higher. You can find more information about our on the PostgreSQL Release notes. Our Help Center is always at your disposal if you have any questions.

• announcement

  PostgreSQL version 17 is now available

  Mar 26, 2025

  We are happy to announce the immediate availability of PostgreSQL version 17. This release delivers significant performance and extensibility enhancements, including: Improved performance for large datasets and complex queries: experience faster processing of large datasets and complex queries. Enhanced parallel query support: Benefit from faster execution times thanks to improved support for parallel queries. Improved JSON and XML data format support: Leverage enhanced support for JSON and XML data formats. As of this week, the larger flavors 16.32 and 16.128 are available again and the “Create Database” endpoint can now be accessed through the Portal. If you have any questions, please feel free to contact us via support ticket.

PostgreSQL Flex Release notes