Pigsty Blog Articles
SLA: Placebo or Insurance?
June 12, 2023 in Cloud
SLA is a marketing tool rather than insurance. In the worst-case scenario, it's an unavoidable loss; at best, it provides emotional comfort.
SLA is a marketing tool rather than insurance. In the worst-case scenario, it's an unavoidable loss; at best, it provides emotional comfort.
Pigsty v2.1: Vector + Full PG Version Support!
June 10, 2023 in Pigsty
Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.
Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.
Back to Basics: Tech Reflection Chronicles
May 29, 2023 in Database
The cost-cutting imperative has triggered a reevaluation of all technologies, including databases. This series critiques hot DB technologies and poses fundamental questions about their trade-offs: Are cloud databases, distributed databases, microservices, and containerization real needs or false hype?
The cost-cutting imperative has triggered a reevaluation of all technologies, including databases. This series critiques hot DB technologies and poses fundamental questions about their trade-offs: Are cloud databases, distributed databases, microservices, and containerization real needs or false hype?
Database Demand Hierarchy Pyramid
May 10, 2023 in Database
Similar to Maslow's hierarchy of needs, user demands for databases also have a progressive hierarchy: physiological needs, safety needs, belonging needs, esteem needs, cognitive needs, aesthetic needs, self-actualization needs, and transcendence needs.
Similar to Maslow's hierarchy of needs, user demands for databases also have a progressive hierarchy: physiological needs, safety needs, belonging needs, esteem needs, cognitive needs, aesthetic needs, self-actualization needs, and transcendence needs.
AI Large Models and Vector Database PGVector
May 10, 2023 in PostgreSQL
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and application of the vector database extension PGVECTOR through a concrete knowledge base retrieval case study.
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and application of the vector database extension PGVECTOR through a concrete knowledge base retrieval case study.
NewSQL: Distributive Nonsens
May 07, 2023 in Database
As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. which makes distributed (TP) databases appear utterly powerless, much like the "data middle platform," donning the emperor's new clothes in a state of self-deception.
As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. which makes distributed (TP) databases appear utterly powerless, much like the "data middle platform," donning the emperor's new clothes in a state of self-deception.
Are Microservices a Bad Idea?
May 07, 2023 in Database
Even Amazons SOA paradigm team admits microservices and Serverless have problems. Prime Video team switched to monolith, saving 90% operational costs.
Even Amazons SOA paradigm team admits microservices and Serverless have problems. Prime Video team switched to monolith, saving 90% operational costs.
EBS: Pig Slaughter Scam
March 15, 2023 in Cloud
The real business model of cloud: **"Cheap" EC2/S3 to attract customers, and fleece with "Expensive" EBS/RDS**
The real business model of cloud: **"Cheap" EC2/S3 to attract customers, and fleece with "Expensive" EBS/RDS**
Garbage QCloud CDN: From Getting Started to Giving Up?
March 08, 2023 in Cloud
I originally believed that at least in IaaS fundamentals — storage, compute, and networking — public cloud vendors could still make significant contributions. However, my personal experience with Tencent Cloud CDN shook that belief: domestic cloud vendors' products and services are truly unbearable.
I originally believed that at least in IaaS fundamentals — storage, compute, and networking — public cloud vendors could still make significant contributions. However, my personal experience with Tencent Cloud CDN shook that belief: domestic cloud vendors' products and services are truly unbearable.
Refuting "Why You Still Shouldn't Hire a DBA"
March 01, 2023 in Cloud
Guo Degang has a comedy routine: "Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed coal. If that scientist takes me seriously, he loses."
Guo Degang has a comedy routine: "Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed coal. If that scientist takes me seriously, he loses."