Posts in 2023
  • v2.2: Observability Overhaul

    2023-08-04 in Releases

    v2.2.0 https://github.com/pgsty/pigsty/releases/tag/v2.2.0 Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)" Release Note: https://doc.pigsty.cc/#/RELEASENOTE?id=v220 Highlight Monitoring Dashboards Overhaul: …

    Read more

  • FinOps: Endgame Cloud-Exit

    2023-07-06 in Cloud Exit

    Featured Image for FinOps: Endgame Cloud-Exit

    At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — cloud-exit and its best practice. TL; DR Misaligned FinOps Focus: Total Cost = Unit Price x Quantity. …

    Read more

  • PostgreSQL, The most successful database

    2023-06-28 in Postgres

    Featured Image for PostgreSQL, The most successful database

    The StackOverflow 2023 Survey, featuring feedback from 90K developers across 185 countries, is out. PostgreSQL topped all three survey categories (used, loved, and wanted), earning its title as the undisputed “Decathlete Database” – …

    Read more

  • SLA: Placebo or Insurance?

    2023-06-12 in Cloud Exit

    Featured Image for SLA: Placebo or Insurance?

    In the world of cloud computing, Service Level Agreements (SLAs) are seen as a cloud provider’s commitment to the quality of its services. However, a closer examination of these SLAs reveals that they might not offer the safety net one might …

    Read more

  • v2.1: Vector Embedding & RAG

    2023-06-09 in Releases

    v2.1.0 PostgreSQL 12 ~ 16 support and pgvector for AI embedding. https://github.com/pgsty/pigsty/releases/tag/v2.1.0 Highlight PostgreSQL 16 beta support, and 12 ~ 15 support. Add PGVector for AI Embedding for 12 - 15 Add 6 extra panel & …

    Read more

  • NewSQL: Distributive Nonsens

    2023-05-07 in Database

    Featured Image for NewSQL: Distributive Nonsens

    WeChat Column As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. In this transformative era, distributed (TP) databases appear utterly powerless, much like the “data middle …

    Read more

  • EBS: Pig Slaughter Scam

    2023-03-15 in Cloud Exit

    Featured Image for EBS: Pig Slaughter Scam

    We already answer the question: Is RDS an Idiot Tax?. But when compared to the hundredfold markup of public cloud block storage, cloud databases seem almost reasonable. This article uses real data to reveal the true business model of public cloud: …

    Read more

  • v2.0: Free RDS PG Alternative

    2023-02-26 in Releases

    v2.0.0 “PIGSTY” is now the abbr of “PostgreSQL in Great STYle” or “PostgreSQL & Infrastructure & Governance System allTogether for You”. Get pigsty v2.0.0 release via the following command: curl -fsSL …

    Read more

  • RDS: The Idiot Tax

    2023-01-30 in Cloud Exit

    Featured Image for RDS: The Idiot Tax

    As the season of layoffs hits big tech companies, cost-cutting and efficiency are top of mind. Public cloud databases, often referred to as the “slaughterhouse knives” of the cloud, are under increasing scrutiny. The question now is: Can …

    Read more

Posts in 2022
  • How Powerful Is PostgreSQL?

    2022-08-22 in Postgres

    Featured Image for How Powerful Is PostgreSQL?

    Last time, we analyzed StackOverflow survey data to explain why PostgreSQL is the most successful database. This time, let’s rely on performance metrics to see just how powerful “the most successful” PostgreSQL really is. We want everyone to walk …

    Read more