Skip to content
Products
Platform
Developer Tools
Portal

PostgreSQL Flex

STACKIT PostgreSQL Flex is a fully managed PostgreSQL database service which automates maintenance, patching and updates. It's fully compatible to the native PostgreSQL database, an advanced ACID-compatible SQL database solution.

Get Started

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

Section titled “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

Section titled “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

Section titled “Latest updates”

PostgreSQL Flex Release notes