Skip to content

This is the multi-page printable view of this section. .

Return to the regular view of this page.

Values Proposition

Pigsty’s 8 core value propositions that deliver infinite possibilities

Pigsty delivers eight core value propositions, giving you an enterprise-ready database platform


Extensible Postgres
    Blossom of Possibilities
Reliable Infra
    Rock-Solid and Secure
Observable Graphics
    Clarity and Vision
Scalable Service
    Elastic Performance
Maintainable Toolbox
    Simple and Actionable
Composable Modules
    Flexible Lego-Blocks
Controllable FOSS
    Sovereign Self-Hosting
Affordable Solution
    Cost-Effective RDS

🧩 Extensible Postgres

“Nurturing all, thriving in synergy, forging infinite possibilities!”

Analytics
    Big Data's New Challenger
AI Ready
    Baseline for RAG/Vector App
Geospatial
    De Facto GIS Standard
Time Series
    Temporal Data Mastery
Text Search
    Built-in Search Engine
Languages
    Language of Your Choice
FDW Federation
    Connecting Data Silos
Featured
    Database as a Platform

🛡️ Reliable Infra

“Towering peaks, bedrock solid, standing firm at any summit!”

High-Availability
    Reliable PostgreSQL RDS
Self-Healing
    Adaptive Service Failover
PITR Protection
    Pre-configured Backup & Archives
Infra Closure
    No External Dependencies
Access Control
    Built-in Best-Practice Model
Confidentiality
    Guaranteed Data Security
Data Integrity
    Thorough Verification
Battle-Tested
    Availability Results

📊 Observable Graphics

“Heaven’s movement, all-seeing view, perceiving details to master the whole!”

Monitoring Infra
    Built-in Observability Stack
Data-Driven
    Measure what you Manage
SOTA Experience
    The Definitive PG monitoring
Universal Monitoring
    RDS or Compat Kernels
Automatic Alerts
    No more manual checks
Performance Tuning
    Slow-query Optimize
Log Analysis
    Fast root-cause detection
Custom Dashboards
    Low-code Data App

⚡ Scalable Service

“Ever-flowing like water, soft yet resilient, converging streams to adapt to endless change!”

Great Performance
    Hardware Fully Harnessed
R/W Separation
    Unlimited Read Scaling
Connection Pooling
    High Concurrency
Load Balancing
    Traffic Control
Horizontal Scaling
    Distributive Extension
Storage Expansion
    Transparent Compression
Mass Deployment
    Large clusters made easy
Elasticity
    Cloud-like Elasticity

🔧 Maintainable Toolbox

“Blazing like wildfire, illuminating all around, burning bright without end!”

Infra as Code
    Define everything in Code
Simple & Easy
    Up and Running in Minutes
Bare Linux
    No Containers or Kubernetes
Offline Install
    Stable, Hassle-free Delivery
Admin SOP
    Best Practices Included
No Downtime
    Online Migration & Resizing
Rich Parameters
    Plenty of Tunable Knobs
Provisioning
    One-command IaaS Provisioning

🎯 Composable Modules

“Swift as the wind, simplifying complexity, riding the currents of change with freedom and ease!”

Modular Design
    Lego-like Assembly
App Templates
    One-Click Enterprise Deployment
Core Modules
    Fully-Featured Postgres RDS
Extra Modules
    Extending RDS Capabilities
Kernel Modules
    Swappable Database Engines
OLAP Modules
    Powerful Analytics Capabilities
Pilot Modules
    Exploring Cutting-Edge Frontiers
Flavor Modules
    Creative Postgres Flavors

🎛️ Controllable FOSS

“Grounded like the earth, gathering all rivers—standing firm while gazing at the stars!”

Software Freedom
    Self-hosting democratized
Local-First
    Run on-premises indefinitely
Multi-Cloud
    No vendor lock-in
Free Extensions
    437 PostgreSQL extensions
Data Ownership
    Pay fair cost for resources
Friendly License
    AGPLv3 preserving freedom
Compliance Ready
    Meeting domestic requirements
Expert Support
    Top-tier PostgreSQL specialists

💰 Affordable Solution

“Thunderous impact, breaking to build anew, keeping costs manageable and value ever rising!”

Open-Source
    Fully leverage PostgreSQL's eco
Save More
    Escape the RDS money pit
DBA Efficiency
    Everyone can be a DBA
Simplified Arch
    No Containers or K8s
Enable Cloud-Exit
    Key blockers resolved
Community Support
    Discuss & Share
Expert Consultation
    Pay as needed
Subscription
    Clear pricing, value for money

These eight values work in synergy to deliver a comprehensive database platform that scales from development to enterprise production environments. Pigsty transforms PostgreSQL from a simple database into a powerful, observable, and maintainable data infrastructure that organizations can truly own and control.

1 - Extensible Postgres

Blossom of Possibilities

Nurturing all, thriving in synergy, forging infinite possibilities!

Analytics
    Big Data's New Challenger
AI Ready
    Baseline for RAG/Vector App
Geospatial
    De Facto GIS Standard
Time Series
    Temporal Data Mastery
Text Search
    Built-in Search Engine
Languages
    Language of Your Choice
FDW Federation
    Connecting Data Silos
Featured
    Database as a Platform

Analytics: Big Data’s New Challenger

T0 analytical performance, DuckDB Extension Battleground, HTAP’s future
Parallelism, MPP, columnar compression, GPU acceleration, Parquet analysis

  • pg_duckdb: Bringing extreme OLAP performance into PostgreSQL
  • pg_mooncake: Columnar Table with top 10 ClickBench rankings
  • pg_strom: GPU accelerating for PostgreSQL/PostGIS
  • citus: Distributed HTAP/OLAP with columnar storage and acceleration

AI Ready: Baseline for RAG/Vector App

Vector database, one extension conquering the entire specialized niche
Complete in-db AI workflow: inference, training, storage, embedding, and RAG

  • pgvector: Vector extension, IVFLAT & HNSW indexing, AVX512 acceleration
  • pgml: Run CUDA with SQL in-database ML/Training/Embedding/Inference
  • Additional extensions: DiskANN, quantization, NN computation, text summarization
  • In-database RAG workflow with vector similarity search

Geospatial: De Facto GIS Standard

De facto standard for GIS, accelerating storage to computation, index & query
Route planning, sky indexing, IP geocoding, H3 indexing

  • PostGIS: Geographic/geometric/topological/raster extension
  • pgrouting: GIS spatial path planning, and graph computation
  • pointcloud: Storage and processing of LiDAR point cloud data

Time Series: Temporal Data Mastery

Enhanced time-series processing & analytics capabilities, for IoT, FinTech, APM
Simplify app dev with temporal tables, time travel, version control, cron tasks

  • timescaledb: Process & Analysis Timeseries, continuous agg of streaming event
  • temporal_tables/e-maj: Time travel capabilities
  • table_version: Version control for table data
  • pg_cron/pg_task: Background task management and scheduling

Built-in full-text search engine with multilingual support
Advanced text processing and search capabilities

  • Built-in full-text search with tsvector and tsquery
  • Multilingual support with various dictionaries
  • Fuzzy matching and similarity search
  • Advanced text analytics and processing

Languages: Language of Your Choice

PostgreSQL is not just a database, but a full-featured data development platform
Support for 20+ stored procedure languages, putting even Oracle to shame

  • Multiple Languages: Python, Js, Java, Shell, Perl, Lua, TCL, PRQL, R, and more
  • pg_tle: Framework for developing extensions using trusted languages
  • Stored Procedure Toolkit: Debugging, Profiling, Validating, Unit testing

FDW Federation: Connecting Data Silos

Create data federations with FDW, becoming the data exchange hub
Uniformly access & ETL all heterogeneous data sources with SQL

  • Major Relational Databases: pgsql, mysql, mssql, oracle, db2, duckdb, sqlite
  • Various Data Sources: redis, kafka, mongo, hdfs, s3, log, jdbc, odbc
  • 20+ FDWs available, write FDWs using WASM
  • Multicorn: Developing FDWs using Python

HTTP requests, SMTP email, compression, QR codes, PDF scanning
Developing web app inside Postgres - Just use PostgreSQL for everything!

  • Dialects: GraphQL, OpenCyper, Jq, PRQL, BSON, SQLite, MQ, HLL
  • Performance Tools: HINT, index advisor
  • Security: Anonymization, TDE
  • Web Development: Omnigres for full-stack web development

2 - Reliable Infra DBMS

Rock-Solid and Secure

Towering peaks, bedrock solid, standing firm at any summit!

High-Availability
    Reliable PostgreSQL RDS
Self-Healing
    Adaptive Service Failover
PITR Protection
    Pre-configured Backup & Archives
Infra Closure
    No External Dependencies
Access Control
    Built-in Best-Practice Model
Confidentiality
    Guaranteed Data Security
Data Integrity
    Thorough Verification
Battle-Tested
    Availability Results

High-Availability: Reliable PostgreSQL RDS

Delivers PG HA solutions following industry best practices.
Adjustable Recovery Time Objective (RTO) and Recovery Point Objective (RPO).

  • Primary failover metrics: RTO ≈ 30 seconds (adjustable)
  • Async commit mode: RPO < 1MB, crit mode: RPO = 0
  • Replica failure / switchover: RTO ≈ 0 seconds

Self-Healing: Adaptive Service Failover

Self-healing architecture with transparent topology and multi-writer experience.
Automatic traffic routing based on health checks and flexible access methods.

  • Industry HA best practices: Patroni, Etcd, HAProxy, VIP Manager
  • 4 default services with read-write splitting
  • Automatic traffic routing based on health checks
  • Flexible access methods: IP, Connection Pools, L2 VIP, L4 LB

PITR Protection: Pre-configured Backup & Archives

Pre-configures physical backups and enables WAL archiving by default.
Protection against software defects and human errors with incremental recovery.

  • Industry backup best practices: pgBackRest + MinIO/Local Disk/S3
  • Protection against software defects and human errors
  • One-command backup and restore
  • In-place concurrent incremental PITR

Infra Closure: No External Dependencies

Complete PostgreSQL RDS infrastructure requiring no external dependencies.
All critical services included for self-contained operation.

  • Observability infrastructure: Prometheus / Grafana
  • Load balancing: Nginx / HAProxy
  • Configuration storage: Etcd / MinIO
  • Critical services: DNSMasq / Chronyd

Access Control: Built-in Best-Practice Model

Default ACL with read/write/admin/analytics/monitoring/DBA separation.
Secure configuration out of the box with role-based access control.

  • Default roles: readonly / readwrite / admin / offline
  • Default users: DBSU / DBA / replication / monitoring
  • Default HBA rule sets
  • Managed pgbouncer db/user credentials

Confidentiality: Guaranteed Data Security

Self-signed CA, SSL encryption, password for backups and endpoints
As long as your passwords & key are secure, your data remains safe.

  • Local CA-issued certificates with SSL/TLS enabled globally by default
  • SCRAM-SHA-256 verification, AES-encrypted backup data
  • Precise allow/deny list default policies to prevent unauthorized access
  • All externally exposed web services are uniformly managed through Nginx

Data Integrity: Thorough Verification

Data checksums for silent corruption. Replicas and delayed standby instances.
Audit extensions and centralized logging, with transparency and efficiency.

  • CRIT configuration template: optimized for data integrity
  • Data checksums enabled to prevent silent data corruption
  • WatchDog: STONITH to prevent cluster split-brain
  • Audit Log: centrally collected, tamper-proof

Battle-Tested: Availability Results

Running robustly in many large organizations, maintain 99.999%+ availability. Ultimate business continuity: rolling upgrades, switchovers, and online migrations

  • No single points of failure: Redundant HA designs for all critical components
  • Zero-downtime migration based on logical replication blue-green deployment
  • Emergency plans: standard SOPs for various failure scenarios
  • Benchmark case: 25,000 vCPU x six years x 99.999% availability

3 - Observable Graphics

Clarity and Vision

Heaven’s movement, all-seeing view, perceiving details to master the whole!

Monitoring Infra
    Built-in Observability Stack
Data-Driven
    Measure what you Manage
SOTA Experience
    The Definitive PG monitoring
Universal Monitoring
    RDS or Compat Kernels
Automatic Alerts
    No more manual checks
Performance Tuning
    Slow-query Optimize
Log Analysis
    Fast root-cause detection
Custom Dashboards
    Low-code Data App

Monitoring Infra: Built-in Observability Stack

Ready-to-use Prometheus & Grafana observability tech stack
Automatic target discovery. Enterprise-grade monitoring without configure

  • Time-series database: Prometheus / AlertManager / X Exporters
  • Visualization: Grafana, Echarts, plus ten extra panels/data sources
  • Log collection: Loki / Promtail

Data-Driven: Measure what you Manage

Monitoring built with data analytics and BI principles, turn metrics into insights
From macro overview to micro details, solid data support for administration

  • 3000+ metrics, 666 pre-agg rules, collecting all possible observation points
  • Unified labels for cross correlation, multi-level dashboard with nav links
  • Laying solid data context for intelligent AIOPS — 《D-Bot LLM as DBA》

SOTA Experience: The Definitive PG monitoring

Five years of refinement for the ultimate PG monitoring experience.
Dig into tables, indexes, func, and query objects details

  • Global/cluster/instance/database/object 5-levels, roll-up / drill-down easily
  • Historical metrics of tables, indexes, functions, queries and other DB objects
  • pg_exporter for postgres/pgbouncer metrics, fully customizable with YAML

Universal Monitoring: RDS or Compat Kernels

Monitoring cloud RDS PG or existing PG-compatible kernels
Monitoring nodes, dbms, apps, LB with correlation analysis

  • Monitoring cloud vendors’ RDS and PG-compatible kernel like Aurora
  • Built-in support for: Node, Infra, MinIO, Etcd, Redis, Haproxy, Nginx…
  • General monitoring solution for servers and other app, easy to integrate

Automatic Alerts: No more manual checks

Production-tested preset alert rule sets with automatic event notification
AlertManager integration: aggregation, silencing, IM connectivity

  • AlertManager integration: aggregation, silencing, IM connectivity
  • 56 preset alert rules covering all built-in Pigsty modules
  • Alert info links to dashboards, improve fault diagnosis efficiency

Performance Tuning: Slow-query Optimize

Combine metrics & catalogs to identify and optimize slow queries quickly
Dashboards for query details, with quantifiable comparison results

  • pg_stat_statements for historical slow query key metrics
  • auto_explain records slow query execution plans and visualizes with PEV
  • Use PGCAT to read and visualize PG catalog related data

Log Analysis: Fast root-cause detection

Unified log collection system with Loki and Promtail, sys db log in one place
Search and filter logs with massive parallel grep, fast and efficient

  • All log streams in one place, associated through labels, flexible search criteria
  • Use PromQL to extract additional metrics from logs, such as error rates
  • Use PGLOG application for interactive analysis of specific PG CSV log samples

Custom Dashboards: Low-code Data App

PostgreSQL + Grafana + Echarts + VolkovLabs datasources/panels
Create interactive data app, quickly build prototypes and visualization demos

  • WHO COVID-19 pandemic data visualization
  • ISD global landmark weather station data visualization
  • StackOverflow database file survey

4 - Scalable Service

Elastic Performance

Ever-flowing like water, soft yet resilient, converging streams to adapt to endless change!

Great Performance
    Hardware Fully Harnessed
R/W Separation
    Unlimited Read Scaling
Connection Pooling
    High Concurrency
Load Balancing
    Traffic Control
Horizontal Scaling
    Distributive Extension
Storage Expansion
    Transparent Compression
Mass Deployment
    Large clusters made easy
Elasticity
    Cloud-like Elasticity

Great Performance: Hardware Fully Harnessed

Highlights amazing scalability and top-tier hardware performance.
Maximizing the potential of modern hardware with optimized configurations.

  • Single-node query rate reaches 2 million rows/second
  • Single-node write rate can reach 1 million rows/second
  • Default table size limit: 32TB (2^32 x 8KiB Page)

R/W Separation: Unlimited Read Scaling

Offers unlimited replicas through cascading replication with auto traffic routing.
Scale read workloads horizontally without impacting write performance.

  • Read-only Service: Route to read-only replicas with primary as backup
  • Offline Service: Route to special analytics instance with replicas as backup
  • Production Case: One primary with 34+ replicas through cascading bridges

Connection Pooling: High Concurrency

Built-in PGBouncer connection pool, ready out of the box and syncing with postgres.
Handle thousands of concurrent connections efficiently with resource optimization.

  • Xact pooling converts 20000+ client connections to several active server connections
  • Enabled by default, automatically syncing db/user with postgres
  • Deploy multiple pgbouncer instances to circumvent bottlenecks

Load Balancing: Traffic Control

Monitor and schedule request traffic in real-time with HAProxy console.
Intelligent traffic distribution with health checks and failover capabilities.

  • Stateless HAProxy can be scaled at will or deployed on dedicated servers
  • Weights can be adjusted via CLI, draining or warming up instances gracefully
  • Password-protected HAProxy GUI exposed uniformly through Nginx

Horizontal Scaling: Distributive Extension

Citus extension with multi-write and multi-tenant capabilities.
Scale beyond single-node limitations with distributed PostgreSQL.

  • Accelerate real-time OLAP analytics using multi-node parallel processing
  • Shard by row key or schema, supporting multi-tenant scenarios
  • Online partition rebalancing, adjusting throughput capacity

Storage Expansion: Transparent Compression

Achieve 10:1 or even higher compression ratios with columnar and other exts
R/W data in S3 with FDW, hot/cold separation and unlimited capacity expansion

  • Use timescaledb, pg_mooncake, pg_duckdb for columnar compression
  • Use duckdb_fdw, pg_parquet, pg_analytics to read/write object storage tables
  • Expand or contract storage with S/H RAID, ZFS, and PG tablespaces

Mass Deployment: Large clusters made easy

Designed for extreme scale - flexible for 25K vCPU clusters or 1c1m node
No limit on nodes per deployment - soft constrained only by monitoring capacity

  • Batch Ops at scale through Ansible, saying goodbye to console ClickOps
  • Largest production deployment record: 25,000 vCPU, 3,000+ instances

Elasticity: Cloud-like Elasticity

Supports cloud EC2 deployment, fully leveraging the elastic advantages of cloud
Flexible multi-cloud strategies - enjoy RDS elasticity with EC2/EBS prices

  • Pigsty only needs cloud servers, works the same across any cloud provider
  • Seamless switching between public, private, hybrid, and multi-cloud
  • Scale compute and storage as needed

5 - Maintainable Toolbox

Simple and Actionable

Blazing like wildfire, illuminating all around, burning bright without end!

Infra as Code
    Define everything in Code
Simple & Easy
    Up and Running in Minutes
Bare Linux
    No Containers or Kubernetes
Offline Install
    Stable, Hassle-free Delivery
Admin SOP
    Best Practices Included
No Downtime
    Online Migration & Resizing
Rich Parameters
    Plenty of Tunable Knobs
Provisioning
    One-command IaaS Provisioning

Infra as Code: Define everything in Code

Declarative API for database deployment and operations
Designed for large-scale cluster management

  • Define databases through config files
  • Designed for batch operations
  • Optional PostgreSQL CMDB solution for programmatic integration

Simple & Easy: Up and Running in Minutes

One-command installation
Pre-configured templates with automatic hardware tuning

  • Config templates for various node counts and scenarios
  • Runs on single-core VMs to high-end physical machines
  • Four instance parameter tuning modes: OLTP / OLAP / CRIT / TINY

Bare Linux: No Containers or Kubernetes

Runs directly on Linux without containers
Supports mainstream Linux distros: EL 8/9, Debian 12, Ubuntu 22/24

  • No K8S required for cloud-native experience
  • Supports x86_64 and ARM64 architectures

Offline Install: Stable, Hassle-free Delivery

Offline installation packages for environments without internet
Snapshots from local repositories

  • Eliminates lengthy downloads
  • Ensures stable installation and version consistency
  • Customized offline packages available in pro subscription

Admin SOP: Best Practices Included

Distills top-tier DBA experience into conventions
Helps avoid common system pitfalls

  • Dev conventions for PostgreSQL features
  • Ops Standard Operating Procedures (SOPs)
  • Security hardening best practices

No Downtime: Online Migration & Resizing

Zero-downtime migration with blue-green deployment
Zero-maintenance window switchovers

  • Comprehensive semi-automated migration playbooks
  • Minimize maintenance windows
  • Fine-grained traffic control with HAPROXY

Rich Parameters: Plenty of Tunable Knobs

Nearly 300+ configurable parameters with defaults suitable for most scenarios
Can adjust to meet demanding customization requirements

  • YAML config format, easy to read, edit, and modify, Ansible compatible
  • Override possible at multiple levels: default, global, cluster, instance, or CLI arg
  • Rich documentation & examples with self-explanatory naming

Provisioning: One-command IaaS Provisioning

Enables running a complete 4-node simulation on a single laptop
Integrated Vagrant/Terraform templates for quick resource provisioning

  • Consistent deployment across production, UAT, staging, testing, and dev environments
  • Complete feature set in a 1-core VM, ideal as a developer’s Devbox environment
  • Multiple Terraform/Vagrant templates available for large-scale IaaS provisioning

6 - Composable Modules

Flexible Lego-Blocks

Swift as the wind, simplifying complexity, riding the currents of change with freedom and ease!

Modular Design
    Lego-like Assembly
App Templates
    One-Click Enterprise Deployment
Core Modules
    Fully-Featured Postgres RDS
Extra Modules
    Extending RDS Capabilities
Kernel Modules
    Swappable Database Engines
OLAP Modules
    Powerful Analytics Capabilities
Pilot Modules
    Exploring Cutting-Edge Frontiers
Flavor Modules
    Creative Postgres Flavors

Modular Design: Lego-like Assembly

Modular design, freely combine components like Lego blocks
Declarative configuration for customizing infrastructure and database environments

  • Ready-to-use high availability clusters (PGSQL + ETCD)
  • Centralized backup with unlimited storage (MINIO + PGSQL)
  • Independent database monitoring (INFRA + NODE)
  • Website hosting and data visualization (INFRA + PGSQL)

App Templates: One-Click Enterprise Deployment

Optional Docker module with Compose templates
Stateless containers that can be destroyed, with state persisted in external HA PGSQL

  • Enterprise apps: GitLab, Odoo, Dify
  • Higher-level databases: Supabase, Neon, EdgeDB
  • Database Admin tools: PGAdmin, Bytebase, PGWEB

Core Modules: Fully-Featured Postgres RDS

4 core modules working together to build a complete PostgreSQL RDS
Scalable, flexible combinations with no additional dependencies

  • PGSQL: PG clusters with HA, PITR, IaC, monitoring, 437 extensions
  • INFRA: Nginx, local repos, Prometheus & Grafana Stack, DNS, NTP
  • NODE: Node management, repo, packages, VIP, logging, NTP
  • ETCD: Distributed config storage for PG high availability

Extra Modules: Extending RDS Capabilities

Components that work exceptionally well with PostgreSQL
Completely optional, install as needed

  • MINIO: S3-compatible object storage, optional PG backup repo
  • REDIS: High-performance dict server in various modes
  • FERRET: MongoDB wire-protocol compatibility for PostgreSQL

Kernel Modules: Swappable Database Engines

Optional replacements for vanilla PostgreSQL kernel
Offering different database compatibility

  • Babelfish: Microsoft SQL Server wire-compatible PG from AWS
  • IvorySQL: Oracle-compatible PostgreSQL 17 kernel from HighGo
  • OpenHalo: MySQL wire-compatible PG kernel by HaloTech
  • OrioleDB: New storage engine without xid wraparound and table bloat

OLAP Modules: Powerful Analytics Capabilities

DuckDB integration showcase
Installation and monitoring support for Greenplum derivatives

  • CITUS: Native distributed HTAP extension for PostgreSQL
  • DUCKDB: Embedded OLAP kernel with 5 PG extensions
  • GREENPLUM: MPP data warehouse (PG 12) with EL monitoring
  • CLOUDBERRY: PG 14 compatible version from original GPSQL team

Pilot Modules: Exploring Cutting-Edge Frontiers

Unrelated to PostgreSQL
Experimental capability explorations

  • KUBE: Kubernetes setup with SealOS, deployment support
  • KAFKA: Message queue powered by KRaft
  • MYSQL: Single-node MySQL 8.0 support
  • VICTORIA: Infrastructure alternative for metrics & logs

Flavor Modules: Creative Postgres Flavors

Diverse wrappers and features on native PostgreSQL
Exploring Backend-as-a-Service, serverless, and in-database web development

  • SUPA: Firebase open-source alternative
  • NEON: Serverless PostgreSQL with database branching
  • EDGE: PostgreSQL with powerful query language
  • OMNI: PostgreSQL with extensions for specific use cases

7 - Controllable FOSS

Sovereign Self-Hosting

Grounded like the earth, gathering all rivers—standing firm while gazing at the stars!

Software Freedom
    Self-hosting democratized
Local-First
    Run on-premises indefinitely
Multi-Cloud
    No vendor lock-in
Free Extensions
    437 PostgreSQL extensions
Data Ownership
    Pay fair cost for resources
Friendly License
    AGPLv3 preserving freedom
Compliance Ready
    Meeting domestic requirements
Expert Support
    Top-tier PostgreSQL specialists

Software Freedom: Self-hosting democratized

100% built upon open-source components
A gift to the PostgreSQL community

  • No license fees or usage limits
  • Free at any scale
  • A reciprocal open-source ecosystem

Local-First: Run on-premises indefinitely

Fully functional even offline
Running forever without external dependencies

  • Supports offline deployment and installation
  • Software snapshotted to local repo
  • Deployable on physical, bare metal, VM, and container VMs

Multi-Cloud: No vendor lock-in

Build your own full-stack DBaaS
Reduce clouds to mere resource providers

  • Use Terraform to provision servers across clouds
  • Blue-green migration via logical replication
  • Cloud services remain optional

Free Extensions

437 PostgreSQL extensions ready to use
Built for PG 17-13 on mainstream distributions

  • Compatible with ten major Linux distros
  • Out-of-the-box RPM/DEB packages
  • Easy installation via extension catalog

Data Ownership

Pay for resources at fair cost
Enjoy cutting-edge hardware advantages

  • Pay roughly 1% of cloud pricing
  • Obtain full database superuser privileges
  • Bypass external RDS support chains

Friendly License

AGPLv3 License preserving software freedom
Essentially Apache 2.0 for end users

  • Mirrors permissive use for typical users
  • Commercial licenses available for DBaaS/OEM

Compliance Ready

Ranked #1 among China-led PG projects
Meets domestic requirements

  • Supports PolarDB v2.0 kernel
  • Enterprise Edition supports domestic OS/chips
  • Aligned with best practices

Expert Support

Top-tier PostgreSQL specialists
Affordable subscription plans

  • Service guarantees for PG and OS
  • Senior experts provide guidance
  • Multiple support tiers available

8 - Affordable Solution

Cost-Effective RDS

Thunderous impact, breaking to build anew, keeping costs manageable and value ever rising!

Open-Source
    Fully leverage PostgreSQL's eco
Save More
    Escape the RDS money pit
DBA Efficiency
    Everyone can be a DBA
Simplified Arch
    No Containers or K8s
Enable Cloud-Exit
    Key blockers resolved
Community Support
    Discuss & Share
Expert Consultation
    Pay as needed
Subscription
    Clear pricing, value for money

Open-Source: Fully leverage PostgreSQL’s eco

Open source doesn’t mean free, and using it effectively can be costly.
Comparison of different PostgreSQL hosting solutions and their costs.

  • Oracle license + support fees: approximately $3,878 / year·vCPU
  • AWS RDS PG fees: approximately $1,920 ~ $2,640 / year·vCPU
  • Pigsty OSS version is free, hardware cost is ~ $27/year·vCPU

Save More: Escape the RDS money pit

Affordable financial cost: escape the expensive pricing traps of RDS
Save 50% to 95%+ compared to cloud database services

  • RDS costs can reach $2,000-$2,600/year·vCPU
  • Self-hosting on cloud EC2, keeping elasticity and saving RDS costs
  • Self-hosting on IDC: Deeply utilize cutting-edge hardware like Gen5 SSDs

DBA Efficiency: Everyone can be a DBA

Affordable manpower cost, transforming Devs and OPS into DBAs
Build enterprise-grade database services with existing team members

  • Encapsulating elite DBA expertise from real-world failures
  • Junior Dev and Ops can perform as mid-senior DBAs with proper tools
  • Build enterprise-grade RDS services without database experts

Simplified Arch: No Containers or K8s

Simplicity matters, no need to use containers and kubernetes
Cloud-native benefits without the operational complexity

  • Cloud-native benefits without complexity
  • No need for rare experts in both K8s and databases
  • Usually only need to worry about: adding disk if space is full

Enable Cloud-Exit: Key blockers resolved

Traditional public cloud services are rapidly losing their value proposition
Database is essential for cloud exit, Pigsty provides the missing piece

  • No longer dependent on cloud services - own your infrastructure
  • Customers with self-build capabilities have true choice
  • Database is essential for cloud exit, Pigsty provides FOSS RDS alternative

Community Support: Discuss & Share

Active user community with free public Q&A support
Multiple channels for getting help and sharing experiences

  • Ask questions in GitHub Issue, report bugs and defects
  • Join WeChat, Telegram, and Discord groups
  • Monthly Office Hour to collect feedback and answer questions

Expert Consultation: Pay as Needed

Professional consultation services available on demand
Flexible pricing for different levels of support needs

  • Quick Consultation: “Coffee or a bit of luck”
  • Professional Consultation: $400 / case, about one hour
  • Support Person Day: $4K / day, complete working day

Subscription: Clear Pricing, Value for Money

Transparent subscription pricing with clear value propositions
Different tiers to meet various organizational needs

  • Standard: Basic support and updates
  • Professional: Enhanced features and priority support
  • Enterprise: Full feature access with dedicated support