Skip to content

Version v3.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

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.