Version v2.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.
Category: Reference
-
AWS & Aliyun Server Pricing
Overview Historical source note: the advertised pigsty-app/cloud directory was not present in the last immutable app repository snapshot before v2.7.0; the SQL and recovered images below come from the frozen documentation repository. Online Demo: …
Overview Historical source note: the advertised pigsty-app/cloud directory was not present in the last immutable app repository snapshot before v2.7.0; the SQL and recovered images below come from the frozen documentation repository. Online Demo: …
-
DB-Engines Database Popularity Trend Analysis
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/db-engine
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/db-engine
-
StackOverflow Global Developer Survey
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/sf-survey
Overview GitHub Repository: https://github.com/Vonng/pigsty-app/tree/11fbbc03031b0a060cf4da0f87f3f12a4ec2f126/db Online Demo: https://demo.pigsty.io/d/sf-survey
-
RELEASENOTE
Version Time Description Release v2.7.0 2024-05-20 Extension Overwhelming, new docker apps v2.7.0 v2.6.0 2024-02-28 PG 16 as default version, ParadeDB & DuckDB v2.6.0 v2.5.1 2023-12-01 Routine update, pg16 major extensions v2.5.1 v2.5.0 2023-10-24 …
Version Time Description Release v2.7.0 2024-05-20 Extension Overwhelming, new docker apps v2.7.0 v2.6.0 2024-02-28 PG 16 as default version, ParadeDB & DuckDB v2.6.0 v2.5.1 2023-12-01 Routine update, pg16 major extensions v2.5.1 v2.5.0 2023-10-24 …
-
PGSQL Architecture
Overview of the PGSQL module and key concepts PGSQL for production environments is organized in clusters, which clusters are logical entities consisting of a set of database instances associated by primary-replica. Each database cluster is an …
Overview of the PGSQL module and key concepts PGSQL for production environments is organized in clusters, which clusters are logical entities consisting of a set of database instances associated by primary-replica. Each database cluster is an …
-
Cost Analysis
Cost Reference EC2 vCPU-Month RDS vCPU-Month DHH’s self-hosted core-month price (192C 384G) 25.32 Junior open-source DBA reference salary 15K/person-month IDC self-hosted data center (exclusive physical machine: 64C384G) 19.53 Intermediate …
Cost Reference EC2 vCPU-Month RDS vCPU-Month DHH’s self-hosted core-month price (192C 384G) 25.32 Junior open-source DBA reference salary 15K/person-month IDC self-hosted data center (exclusive physical machine: 64C384G) 19.53 Intermediate …
-
Comparison
Comparing to RDS Pigsty is an AGPLv3-licensed, local-first RDS alternative that can be deployed on your own physical machines/virtual machines, or on cloud servers. Therefore, we chose the world’s leading Amazon Cloud AWS RDS for PostgreSQL and …
Comparing to RDS Pigsty is an AGPLv3-licensed, local-first RDS alternative that can be deployed on your own physical machines/virtual machines, or on cloud servers. Therefore, we chose the world’s leading Amazon Cloud AWS RDS for PostgreSQL and …
-
File Hierarchy
Pigsty FHS #------------------------------------------------------------------------------ # pigsty # ^-----@app # extra demo application resources # ^-----@bin # bin scripts # ^-----@docs # document (can be docsified) # ^-----@files # ansible file …
Pigsty FHS #------------------------------------------------------------------------------ # pigsty # ^-----@app # extra demo application resources # ^-----@bin # bin scripts # ^-----@docs # document (can be docsified) # ^-----@files # ansible file …
-
Parameters
There are 280+ parameters in Pigsty describing all aspect of the deployment. ID Name Module Section Type Level Comment 101 version INFRA META string G pigsty version string 102 admin_ip INFRA META ip G admin node ip address 103 region INFRA META …
There are 280+ parameters in Pigsty describing all aspect of the deployment. ID Name Module Section Type Level Comment 101 version INFRA META string G pigsty version string 102 admin_ip INFRA META ip G admin node ip address 103 region INFRA META …