PostgreSQL
Why PostgreSQL is the Most Successful Database?
July 12, 2022 in PostgreSQL
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won all three categories, becoming literally the "most successful database"
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won all three categories, becoming literally the "most successful database"
Ready-to-Use PostgreSQL Distribution: Pigsty
May 24, 2021 in PostgreSQL
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty
Why Does PostgreSQL Have a Bright Future?
May 08, 2021 in PostgreSQL
Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?
Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world's most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?
Localization and Collation Rules in PostgreSQL
March 05, 2021 in PostgreSQL
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!
Implementing Advanced Fuzzy Search
March 05, 2021 in PostgreSQL
How to implement relatively complex fuzzy search logic in PostgreSQL?
How to implement relatively complex fuzzy search logic in PostgreSQL?
PostgreSQL Logical Replication Deep Dive
March 03, 2021 in PostgreSQL
This article introduces the principles and best practices of logical replication in PostgreSQL 13.
This article introduces the principles and best practices of logical replication in PostgreSQL 13.
PG Replica Identity Explained
March 03, 2021 in PostgreSQL
Replica identity is important - it determines the success or failure of logical replication
Replica identity is important - it determines the success or failure of logical replication
A Methodology for Diagnosing PostgreSQL Slow Queries
February 23, 2021 in PostgreSQL
Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.
Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.
Incident-Report: Patroni Failure Due to Time Travel
February 22, 2021 in PostgreSQL
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Machine restarted due to failure, NTP service corrected PG time after PG startup, causing Patroni to fail to start.
Online Primary Key Column Type Change
January 15, 2021 in PostgreSQL
How to change column types online, such as upgrading from INT to BIGINT?
How to change column types online, such as upgrading from INT to BIGINT?