BestHub
Sign in
Tagged articles

PostgreSQL

571 articles · Page 3 of 6
dbaplus Community
dbaplus Community
Oct 7, 2024 · Databases

How Do Chinese Databases Compare in Compatibility? A Detailed Survey

This article surveys the compatibility of major Chinese database products with Oracle, MySQL, PostgreSQL and other systems, covering compatibility targets, levels, assessment methods, migration tools, and specific feature support such as protocols, data types, character sets, SQL syntax, procedural languages, built‑in functions, system views, optimizer capabilities and security features.

Chinese databasesDatabase CompatibilityEvaluation Tools
0 likes · 26 min read
How Do Chinese Databases Compare in Compatibility? A Detailed Survey
ITPUB
ITPUB
Sep 28, 2024 · Databases

What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts

PostgreSQL 17, announced on 2024‑09‑26, brings major performance upgrades, extensive SQL/JSON enhancements, improved logical replication, new security and management options, and a host of developer‑friendly features that position it as the world’s most advanced open‑source database.

DatabaseLogical ReplicationPostgreSQL
0 likes · 14 min read
What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts
21CTO
21CTO
Sep 27, 2024 · Databases

What’s New in PostgreSQL 17? Incremental Backup, SQL/JSON Boosts, and SLRU Cache

PostgreSQL 17 introduces a highly optimized incremental backup built into the core, expanded SQL/JSON functions aligned with the SQL:2023 standard, and a configurable SLRU cache, all aimed at improving performance, recovery speed, and developer productivity for modern database workloads.

Database FeaturesPostgreSQLSLRU Cache
0 likes · 6 min read
What’s New in PostgreSQL 17? Incremental Backup, SQL/JSON Boosts, and SLRU Cache
ITPUB
ITPUB
Sep 23, 2024 · Databases

Master PostgreSQL Table Partitioning: Types, Commands, and Best Practices

This guide explains PostgreSQL table partitioning, covering its definition, benefits, drawbacks, the three partition types (RANGE, LIST, HASH), step‑by‑step SQL commands for creating partitions, indexes, and managing them, and concludes with practical recommendations for effective use.

DatabaseHashPartitioning
0 likes · 10 min read
Master PostgreSQL Table Partitioning: Types, Commands, and Best Practices
21CTO
21CTO
Aug 31, 2024 · Databases

MongoDB Claims Edge Over PostgreSQL with Atlas Wins and Strong Q2 Growth

MongoDB reported a 13% revenue rise to $478.1 million in Q2 2025, highlighted a major win over PostgreSQL at Fanatics Betting & Gaming, and emphasized its flexible JSON‑like architecture, horizontal scaling, and sharding advantages while noting ongoing competition and a revised growth outlook.

ATLASMongoDBNoSQL
0 likes · 5 min read
MongoDB Claims Edge Over PostgreSQL with Atlas Wins and Strong Q2 Growth
dbaplus Community
dbaplus Community
Aug 25, 2024 · Databases

Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching

This article introduces ReadySet, an open‑source SQL caching layer for MySQL and PostgreSQL, explains its architecture and advantages, and provides step‑by‑step instructions for installing the Docker image, configuring connections, creating caches, and testing query performance to achieve millisecond‑level response times.

DatabaseDockerMySQL
0 likes · 7 min read
Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching
MaGe Linux Operations
MaGe Linux Operations
Aug 24, 2024 · Databases

Recovering PostgreSQL After Power Loss: Fixing Invalid Checkpoint Errors

After a power outage caused a PostgreSQL instance running in Kubernetes to fail with connection errors and an invalid primary checkpoint record, this guide explains how to diagnose missing socket files, inspect process IDs, use pg_resetwal to repair the checkpoint, and successfully restart the database.

Checkpoint RepairDatabase RecoveryKubernetes
0 likes · 5 min read
Recovering PostgreSQL After Power Loss: Fixing Invalid Checkpoint Errors
21CTO
21CTO
Aug 13, 2024 · Databases

How PostgreSQL Can Replace Kafka, Redis, MongoDB and More in Your Stack

This article explores how PostgreSQL’s advanced features—UNLOGGED tables, JSONB, SKIP LOCKED, TimescaleDB, pg_cron, PostGIS, full‑text search, JSON generation, pgaudit, and GraphQL adapters—can replace specialized tools like Kafka, Redis, MongoDB, and others, simplifying the tech stack while boosting performance and maintainability.

Data WarehouseFull-text SearchGraphQL
0 likes · 23 min read
How PostgreSQL Can Replace Kafka, Redis, MongoDB and More in Your Stack
ITPUB
ITPUB
Aug 7, 2024 · Databases

Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss

This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.

MySQLOraclePostgreSQL
0 likes · 19 min read
Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss
Top Architect
Top Architect
Aug 3, 2024 · Backend Development

Optimizing a High‑Concurrency Transaction Statistics Interface from 30 seconds to Sub‑Second Performance

This article presents a real‑world case study of a high‑concurrency data‑processing interface whose response time was reduced from 30 seconds to under one second by diagnosing SQL bottlenecks, refactoring MyBatis code, applying PostgreSQL array aggregation, and introducing a Caffeine cache, while also discussing the limits of relational databases and promoting related AI services.

CaffeineMyBatisPostgreSQL
0 likes · 13 min read
Optimizing a High‑Concurrency Transaction Statistics Interface from 30 seconds to Sub‑Second Performance
Java Architect Essentials
Java Architect Essentials
Aug 2, 2024 · Databases

Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts

This article details the step‑by‑step process of switching a SpringBoot‑MyBatisPlus application from MySQL to PostgreSQL, covering driver integration, JDBC configuration changes, numerous SQL and type‑conversion pitfalls, and provides ready‑to‑run PostgreSQL scripts for bulk column adjustments and default values.

Database MigrationMySQLPostgreSQL
0 likes · 11 min read
Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts
ITPUB
ITPUB
Jul 30, 2024 · Databases

Why PostgreSQL Reports ‘invalid memory alloc request size’ and How to Fix It

The article explains PostgreSQL's 1 GB memory allocation limit, shows how inserting large BYTEA values triggers the “invalid memory alloc request size” error, explores the underlying memory‑context code, and offers practical work‑arounds for migration from Oracle.

BYTEADatabase LimitsMaxAllocSize
0 likes · 8 min read
Why PostgreSQL Reports ‘invalid memory alloc request size’ and How to Fix It
Java Architect Essentials
Java Architect Essentials
Jul 29, 2024 · Backend Development

Optimizing a High‑Concurrency Interface: Reducing Response Time from 30 seconds to 0.8 seconds

This article presents a real‑world case study of a high‑concurrency transaction‑statistics API that originally took 30 seconds to respond, detailing problem diagnosis, SQL and Java code analysis, and a series of optimizations—including SQL rewrites, database‑side calculations, and Caffeine caching—that ultimately brought the response time below one second.

PostgreSQLSQL Optimizationcaching
0 likes · 10 min read
Optimizing a High‑Concurrency Interface: Reducing Response Time from 30 seconds to 0.8 seconds
Code Ape Tech Column
Code Ape Tech Column
Jul 18, 2024 · Backend Development

Optimizing a High‑Concurrency Data Processing Interface: Reducing Response Time from 30 s to 0.8 s

This article presents a real‑world case study of a high‑concurrency transaction‑handling API that originally required 30 seconds to process over two million records, and details the step‑by‑step SQL, Java, and caching optimizations that brought the response time down to under one second.

MyBatisPostgreSQLSQL Optimization
0 likes · 10 min read
Optimizing a High‑Concurrency Data Processing Interface: Reducing Response Time from 30 s to 0.8 s
Top Architect
Top Architect
Jul 10, 2024 · Backend Development

Optimizing a High-Concurrency Interface: Reducing Response Time from 30 s to 0.8 s with SQL Refactoring and Caffeine Caching

This article presents a real‑world case of optimizing a high‑concurrency transaction‑statistics API, detailing diagnosis of a 30‑second latency, SQL refactoring with array_agg and unnest, Java‑level improvements, and Caffeine caching, while also sharing promotional offers for ChatGPT services and a developer community.

CaffeinePostgreSQLSQL
0 likes · 13 min read
Optimizing a High-Concurrency Interface: Reducing Response Time from 30 s to 0.8 s with SQL Refactoring and Caffeine Caching
dbaplus Community
dbaplus Community
Jul 7, 2024 · Operations

How Instagram Scales to 2.5B Users: Architecture, Consistency & Performance

Instagram grew from a simple photo‑sharing app to over 2.5 billion users, prompting engineers to adopt horizontal scaling, replace Python code with Cython, use region‑specific Cassandra clusters, employ the Akkio data‑placement service, and optimize PostgreSQL and Memcache handling to improve resource utilization, data consistency, and latency.

CassandraInstagramPostgreSQL
0 likes · 11 min read
How Instagram Scales to 2.5B Users: Architecture, Consistency & Performance
Architect
Architect
Jul 5, 2024 · Databases

Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication

This article provides a comprehensive, hands‑on tutorial for planning, installing, configuring, and verifying a PostgreSQL master‑slave (streaming replication) setup on two Linux nodes, including user creation, remote connection settings, data export/import, and troubleshooting tips.

ConfigurationDatabaseLinux
0 likes · 14 min read
Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication
21CTO
21CTO
Jul 1, 2024 · Databases

MongoDB vs PostgreSQL: Which Handles GenAI Workloads Better?

This article compares MongoDB’s document‑oriented storage with PostgreSQL’s relational model for generative AI workloads, detailing how JSON, JSONB, and BSON affect insert and read performance across a series of benchmarks on identical hardware.

BSONDatabase PerformanceGenAI
0 likes · 11 min read
MongoDB vs PostgreSQL: Which Handles GenAI Workloads Better?
ITPUB
ITPUB
Jun 30, 2024 · Databases

How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×

This article explains how implicit type conversions in PostgreSQL can cause index loss, drastically misestimate row counts, and force inefficient join strategies, illustrating the issue with concrete examples, detailed execution plans, and step‑by‑step optimizations that restore index usage and boost performance thousands of times.

Implicit ConversionPostgreSQLSQL
0 likes · 13 min read
How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×
21CTO
21CTO
Jun 14, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

An in‑depth comparison of PostgreSQL and MySQL covers their histories, ACID compliance, performance, scalability, advanced features, security, backup strategies, installation on Linux, and provides practical SQL code examples to help full‑stack developers choose the right open‑source relational database for their projects.

Database ComparisonLinuxMySQL
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
Java Tech Enthusiast
Java Tech Enthusiast
Jun 13, 2024 · Databases

MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL

Oracle’s post‑acquisition strategy has left MySQL lagging behind modern developers, while PostgreSQL, praised for features like parallel queries and vector search, now dominates the open‑source database market, prompting calls for MySQL’s transfer to the Linux Foundation to avoid obsolescence.

DB-EnginesMySQLOpen Source
0 likes · 7 min read
MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL
dbaplus Community
dbaplus Community
Jun 10, 2024 · Backend Development

How to Seamlessly Switch a SpringBoot MyBatisPlus Project from MySQL to PostgreSQL

This guide walks you through migrating a SpringBoot + MyBatis‑Plus application from MySQL to PostgreSQL, covering driver addition, JDBC configuration changes, common SQL syntax pitfalls, transaction handling quirks, and provides batch scripts for schema adjustments and type conversions to ensure a smooth transition.

Database MigrationMybatisPlusPostgreSQL
0 likes · 12 min read
How to Seamlessly Switch a SpringBoot MyBatisPlus Project from MySQL to PostgreSQL
Architect's Guide
Architect's Guide
May 30, 2024 · Databases

MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases

The article compares MySQL and PostgreSQL, covering their histories, architecture hierarchies, benchmark performance on SELECT/INSERT/UPDATE, suitable use cases, and summarizes PostgreSQL’s advantages and disadvantages relative to MySQL, providing guidance for choosing the appropriate database.

Database ComparisonMySQLPostgreSQL
0 likes · 9 min read
MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases
21CTO
21CTO
May 29, 2024 · Databases

Why PostgreSQL Is the 2024 SQL Powerhouse Reviving Database Innovation

Amid the rise of vector databases, AI, and cloud computing, this article explains how PostgreSQL’s flexibility, extensibility, and open‑source community are reigniting SQL’s relevance in 2024, uniting OLTP and OLAP workloads and positioning PostgreSQL as the versatile backbone for modern data management.

Data ManagementOpen source databasesPostgreSQL
0 likes · 4 min read
Why PostgreSQL Is the 2024 SQL Powerhouse Reviving Database Innovation
ITPUB
ITPUB
May 25, 2024 · Backend Development

How Infisical Migrated from MongoDB to PostgreSQL and What You Can Learn

Infisical’s engineering team recounts their three‑month journey of moving from MongoDB to PostgreSQL, detailing the motivations, technical challenges, ORM choices, migration planning, execution steps, and the performance and reliability gains achieved after the switch.

Database MigrationInfisicalKnex.js
0 likes · 13 min read
How Infisical Migrated from MongoDB to PostgreSQL and What You Can Learn
ITPUB
ITPUB
May 24, 2024 · Databases

Master PostgreSQL High Availability with Pacemaker & Corosync: A Step‑by‑Step Guide

This tutorial walks through building a PostgreSQL high‑availability cluster using Pacemaker and Corosync, covering architecture overview, component installation, cluster status checks, data synchronization verification, failover handling, and common maintenance commands with concrete commands and screenshots.

ClusterCorosyncDatabase
0 likes · 7 min read
Master PostgreSQL High Availability with Pacemaker & Corosync: A Step‑by‑Step Guide
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
May 16, 2024 · Databases

Why MySQL Dominates in Mainland China While PostgreSQL Remains Secondary, and Can PostgreSQL Replace MySQL?

The article analyses the historical, technical, and market reasons why MySQL became the mainstream database in mainland China, contrasts its simplicity and performance with PostgreSQL's advanced transaction and consistency features, and discusses whether PostgreSQL can realistically replace MySQL in enterprise scenarios.

ChinaDatabase ComparisonMySQL
0 likes · 6 min read
Why MySQL Dominates in Mainland China While PostgreSQL Remains Secondary, and Can PostgreSQL Replace MySQL?
dbaplus Community
dbaplus Community
May 12, 2024 · Databases

Why Infisical Switched from MongoDB to PostgreSQL—and How They Did It

Infisical, an open‑source secret‑management platform, migrated its data store from MongoDB to PostgreSQL to overcome transaction, schema, and cloud‑provider limitations, detailing the decision process, ORM choice, migration planning, execution steps, and the performance and usability benefits achieved.

Database MigrationInfisicalKnex.js
0 likes · 13 min read
Why Infisical Switched from MongoDB to PostgreSQL—and How They Did It
ITPUB
ITPUB
May 5, 2024 · Databases

What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design

This article examines GitLab’s extensive PostgreSQL schema, explaining why the project uses a pure‑SQL structure file, how primary‑key choices, internal versus external IDs, naming conventions, timestamps, text types, partitioning, GIN indexes, JSONB columns, foreign‑key strategies and other data‑type decisions impact performance, maintainability, and scalability.

JSONBPartitioningPostgreSQL
0 likes · 25 min read
What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design
The Dominant Programmer
The Dominant Programmer
Apr 23, 2024 · Fundamentals

How to Write, Convert, and Read WKB Data with JTS in Java

This article explains the WKB binary format, its storage advantages in MySQL and PostgreSQL, and provides step‑by‑step Java code using JTS's GeometryFactory, WKBWriter, and WKBReader to write a Point to WKB, convert it to a hex string, and read it back into a geometry object.

GeometryJTSMySQL
0 likes · 3 min read
How to Write, Convert, and Read WKB Data with JTS in Java
Java Architect Essentials
Java Architect Essentials
Apr 19, 2024 · Backend Development

Improving Million-Scale Data Insertion Efficiency with Spring Boot ThreadPoolTaskExecutor

This article demonstrates how to boost the performance of inserting over two million records by configuring a ThreadPoolTaskExecutor in a Spring Boot application, providing detailed implementation code, test results comparing multithreaded and single‑threaded approaches, and practical recommendations for optimal thread pool sizing.

BatchInsertPerformanceTestingPostgreSQL
0 likes · 6 min read
Improving Million-Scale Data Insertion Efficiency with Spring Boot ThreadPoolTaskExecutor
ITPUB
ITPUB
Apr 18, 2024 · Databases

Essential PostgreSQL Features: Versioned Schemas, Online Migrations, Git‑Style Branching

The article outlines a developer‑focused wishlist for PostgreSQL, proposing built‑in versioned schemas, online schema changes, instant branch creation akin to Git, configurable archive tables, a flexible key‑value labeling system, and tighter Git integration, while highlighting industry examples such as Neon, Xata, Snaplet, Supabase and Bytebase.

Database DevelopmentGit integrationPostgreSQL
0 likes · 8 min read
Essential PostgreSQL Features: Versioned Schemas, Online Migrations, Git‑Style Branching
21CTO
21CTO
Apr 12, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

This article compares PostgreSQL and MySQL across history, ACID compliance, performance, scalability, advanced features, tooling, security, backup strategies, and Linux installation steps, helping full‑stack developers choose the most suitable open‑source relational database for their projects.

ACIDBackupDatabase Comparison
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
21CTO
21CTO
Apr 11, 2024 · Databases

Why PostgreSQL Is Becoming the Dominant Database Framework

This article traces PostgreSQL’s evolution from an academic project to a versatile data‑management framework, highlights its extensive extensions, performance benchmarks, and the shifting landscape of OLTP/OLAP, showing how its open‑source extensibility is reshaping the entire database world.

DatabaseOpen SourcePostgreSQL
0 likes · 18 min read
Why PostgreSQL Is Becoming the Dominant Database Framework
ITPUB
ITPUB
Mar 27, 2024 · Backend Development

How Instagram Scaled to 14 Million Users with Just Three Engineers

This article details how Instagram grew from zero to 14 million users in just over a year using three engineers by applying three core principles and a reliable AWS‑based tech stack covering frontend, load balancing, backend, PostgreSQL sharding, S3 storage, Redis caching, asynchronous task queues, and comprehensive monitoring.

AWSInstagramMonitoring
0 likes · 9 min read
How Instagram Scaled to 14 Million Users with Just Three Engineers
Java Architect Essentials
Java Architect Essentials
Mar 25, 2024 · Databases

MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases

This article introduces MySQL and PostgreSQL, compares their architectures and benchmark results, highlights performance differences in SELECT, INSERT, and UPDATE operations, and discusses suitable scenarios and trade‑offs to help developers choose the appropriate database for their applications.

Database ComparisonMySQLPostgreSQL
0 likes · 9 min read
MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases
Architect
Architect
Mar 18, 2024 · Databases

MySQL vs PostgreSQL: Overview, Performance Benchmark, and Use‑Case Guidance

The article introduces MySQL and PostgreSQL, compares their performance through a benchmark on identical hardware, discusses each system’s strengths, weaknesses, and suitable application scenarios, and provides guidance on choosing the appropriate database for different workloads.

Data ReplicationDatabase ComparisonMySQL
0 likes · 8 min read
MySQL vs PostgreSQL: Overview, Performance Benchmark, and Use‑Case Guidance
ITPUB
ITPUB
Feb 19, 2024 · Databases

What Caused Linear’s Massive Data Loss and How They Recovered It

Linear, the SaaS project‑management tool, suffered a catastrophic data loss when a TRUNCATE CASCADE command unintentionally wiped production tables, prompting a detailed post‑mortem that outlines the timeline, root cause, recovery steps, impact, and a set of concrete preventive measures.

CI/CDDataRecoveryDatabase
0 likes · 10 min read
What Caused Linear’s Massive Data Loss and How They Recovered It
Programmer DD
Programmer DD
Feb 19, 2024 · Backend Development

How to Build a Full‑Text Search API with Spring Boot and PostgreSQL

This guide explains how to implement a searchable user‑story interface using PostgreSQL tables with btree and gin indexes, Java record models, Spring Boot data access, and REST controllers to support range and full‑text queries efficiently.

Full-text SearchPostgreSQLSQL
0 likes · 9 min read
How to Build a Full‑Text Search API with Spring Boot and PostgreSQL
21CTO
21CTO
Jan 20, 2024 · Databases

How Michael Stonebraker Is Turning Databases Into Operating Systems

The article chronicles Michael Stonebraker’s pioneering journey from early relational databases like Ingres to PostgreSQL’s open‑source success, his critique of NoSQL, the rise of cloud‑compatible PostgreSQL services, and his latest DBOS concept that reimagines operating systems as database‑driven platforms.

DBMSDBOSDatabase Operating System
0 likes · 12 min read
How Michael Stonebraker Is Turning Databases Into Operating Systems
21CTO
21CTO
Jan 5, 2024 · Databases

Why PostgreSQL Won DB‑Engines 2023 DBMS of the Year (and Who Came Close)

The article explains how PostgreSQL was crowned DB‑Engines 2023 Database Management System of the Year, outlines the ranking methodology, highlights PostgreSQL’s long‑term success, and introduces the runner‑up Databricks and third‑place Google BigQuery along with a history of past winners.

BigQueryDB-EnginesDatabase Rankings
0 likes · 4 min read
Why PostgreSQL Won DB‑Engines 2023 DBMS of the Year (and Who Came Close)
21CTO
21CTO
Dec 29, 2023 · Databases

What Michael Stonebraker’s 80-Year Journey Teaches About Modern Databases

Celebrating Michael Stonebraker’s 80th birthday, this article chronicles his pioneering work from Ingres to PostgreSQL, his influence on open‑source databases, the rise of cloud‑compatible DBMS, and his bold vision of a database‑centric operating system reshaping the future of data management.

DBMSDatabase OSDatabases
0 likes · 11 min read
What Michael Stonebraker’s 80-Year Journey Teaches About Modern Databases
dbaplus Community
dbaplus Community
Dec 18, 2023 · Databases

Is Running Production Databases in Docker a Good Idea? Risks and Realities

The article critically examines the suitability of placing production databases in Docker containers, highlighting reliability, maintainability, performance, and operational complexities, and concludes that while containers offer some benefits for stateless services, they often compromise the essential stability required for stateful database workloads.

DockerPostgreSQLcontainerization
0 likes · 20 min read
Is Running Production Databases in Docker a Good Idea? Risks and Realities
IT Services Circle
IT Services Circle
Dec 10, 2023 · Databases

Should Production Databases Be Deployed in Docker/Kubernetes? A Critical Analysis

The article critically examines the drawbacks of running production databases inside Docker containers or Kubernetes, arguing that while containers excel for stateless services, they introduce reliability, performance, maintenance, and complexity challenges that make them unsuitable for critical stateful database workloads.

DatabaseDockerKubernetes
0 likes · 20 min read
Should Production Databases Be Deployed in Docker/Kubernetes? A Critical Analysis
dbaplus Community
dbaplus Community
Dec 9, 2023 · Databases

Why MySQL Still Beats PostgreSQL in China: A Deep Dive

An in‑depth analysis shows that MySQL’s early Windows support, lower entry barrier, strong LAMP ecosystem, backing from major Chinese tech firms, and a mature tooling landscape together explain why it remains far more popular than PostgreSQL across China despite global growth trends.

ChinaDatabase PopularityEcosystem
0 likes · 9 min read
Why MySQL Still Beats PostgreSQL in China: A Deep Dive
Sohu Tech Products
Sohu Tech Products
Dec 6, 2023 · Databases

GPTuner: LLM-Driven PostgreSQL Knob Tuning

GPTuner, an LLM‑driven system for PostgreSQL knob tuning developed by researchers at Sichuan University, demonstrates that knowledge processing, parameter selection, search‑range optimization, and a two‑stage Bayesian framework each significantly improve performance, while costing roughly 880 000 GPT‑4 tokens (≈ $30) with reusable knowledge.

GPTunerLLMPostgreSQL
0 likes · 9 min read
GPTuner: LLM-Driven PostgreSQL Knob Tuning
Hacker Afternoon Tea
Hacker Afternoon Tea
Dec 4, 2023 · Cloud Native

Managing StackGres 1.6 HA Clusters Fully with Patroni

This guide walks through identifying master and replica pods, performing graceful switchover, triggering automated failover, and reinitializing replicas in a StackGres 1.6 cluster using kubectl and patronictl commands, with practical notes and safety warnings.

FailoverHAKubernetes
0 likes · 10 min read
Managing StackGres 1.6 HA Clusters Fully with Patroni
Hacker Afternoon Tea
Hacker Afternoon Tea
Nov 30, 2023 · Cloud Native

StackGres 1.6: A Private‑Deployable Cloud‑Native PostgreSQL Platform

StackGres 1.6 is a full‑stack, production‑grade PostgreSQL distribution for Kubernetes that bundles a curated set of components—including Patroni, WAL‑G, PgBouncer, Envoy, and monitoring tools—into a single declarative deployment unit with multiple access methods, sidecar architecture, and built‑in high‑availability, backup, and observability features.

BackupCloud NativeHigh Availability
0 likes · 16 min read
StackGres 1.6: A Private‑Deployable Cloud‑Native PostgreSQL Platform
21CTO
21CTO
Nov 12, 2023 · Databases

From INGRES to PostgreSQL: How the Open‑Source RDBMS Became a Developer Favorite

This article traces PostgreSQL's origins from the 1980s INGRES project, compares navigation and relational databases, outlines its evolution through Postgres95 to PostgreSQL, and highlights ten modern features that make it a powerful, scalable, and secure choice for developers today.

Data TypesDatabase FeaturesOpen Source
0 likes · 17 min read
From INGRES to PostgreSQL: How the Open‑Source RDBMS Became a Developer Favorite
Efficient Ops
Efficient Ops
Nov 8, 2023 · Databases

Which Database Reigns Supreme? MySQL vs PostgreSQL Deep Dive

This article analyzes the popularity, success metrics, distributed versus centralized architectures, TPC‑C benchmark relevance, and a detailed feature comparison between MySQL and PostgreSQL, concluding which system currently leads in real‑world OLTP deployments.

DB-EnginesDatabase ComparisonMySQL
0 likes · 16 min read
Which Database Reigns Supreme? MySQL vs PostgreSQL Deep Dive
ITPUB
ITPUB
Nov 6, 2023 · Databases

Why MySQL Dominates China While PostgreSQL Lags Behind

Despite PostgreSQL’s rapid global growth, MySQL remains the leading database in China, a gap explained by early Windows support, the entrenched LAMP stack, lower entry barriers, extensive tooling, and strong backing from major tech firms, as illustrated by trend data and ecosystem analysis.

ChinaDatabase PopularityEcosystem
0 likes · 9 min read
Why MySQL Dominates China While PostgreSQL Lags Behind
ITPUB
ITPUB
Oct 26, 2023 · Databases

Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL

This guide explains why case‑sensitivity issues arise in databases, how naming conventions can prevent them, and compares the behavior of Snowflake, Databend, MySQL, and PostgreSQL for database, table, column names and string literals, complete with practical examples and a concise checklist.

DatabasesDatabendMySQL
0 likes · 6 min read
Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL
ITPUB
ITPUB
Sep 26, 2023 · Databases

Why PostgreSQL Shows InitPlan and One‑Time Filter in Self‑Join Queries

This article walks through a puzzling PostgreSQL self‑join query, shows how different alias placements change the execution plan, explains the meaning of InitPlan and One‑Time Filter nodes, and demonstrates their impact with concrete examples and EXPLAIN output.

InitPlanOne-Time FilterPostgreSQL
0 likes · 11 min read
Why PostgreSQL Shows InitPlan and One‑Time Filter in Self‑Join Queries
ITPUB
ITPUB
Sep 23, 2023 · Databases

Is PostgreSQL Really the Most Popular Database? A Deep Dive into Rankings, Architecture, and Performance

This article examines why PostgreSQL appears to outrank MySQL in recent popularity surveys, explains the DB‑Engines ranking methodology, compares architectural choices such as MVCC, multi‑process vs multi‑thread models, transaction rollback behavior, licensing, and real‑world performance benchmarks like TPC‑C, ultimately revealing that MySQL still dominates many high‑throughput OLTP scenarios.

Database ComparisonMVCCMySQL
0 likes · 17 min read
Is PostgreSQL Really the Most Popular Database? A Deep Dive into Rankings, Architecture, and Performance
Tencent Cloud Developer
Tencent Cloud Developer
Sep 18, 2023 · Databases

Who Is the World's Most Successful Database? An In‑Depth Technical Comparison of PostgreSQL and MySQL

The article evaluates database success by comparing PostgreSQL and MySQL across popularity, features, licensing, transaction behavior, MVCC, concurrency models, and use cases, showing PostgreSQL leads in complex queries and feature richness while MySQL remains the most widely used OLTP system, especially in China.

DB-EnginesDatabase ComparisonMVCC
0 likes · 15 min read
Who Is the World's Most Successful Database? An In‑Depth Technical Comparison of PostgreSQL and MySQL
dbaplus Community
dbaplus Community
Sep 7, 2023 · Databases

How to Safely Migrate from MySQL 5.7 Before Its End‑of‑Life

With MySQL 5.7 reaching end‑of‑life in October 2023 and over half of installations still on that version, this guide explains the new features of MySQL 8.0, how to assess upgrade readiness, and the three main migration paths—including staying put, moving to a DBaaS, or switching to PostgreSQL.

DBaaSEOLMySQL
0 likes · 8 min read
How to Safely Migrate from MySQL 5.7 Before Its End‑of‑Life
ITPUB
ITPUB
Sep 3, 2023 · Databases

Migrating from MySQL 5.7 to 8.0: Steps, New Features, and Alternative Paths

With MySQL 5.7 reaching end‑of‑life, this guide explains why you should upgrade to MySQL 8.0, outlines the new SQL capabilities and tools, and compares migration options including DBaaS and switching to PostgreSQL, helping you choose the best path for your workloads.

DBaaSDatabase UpgradeMigration
0 likes · 8 min read
Migrating from MySQL 5.7 to 8.0: Steps, New Features, and Alternative Paths
ITPUB
ITPUB
Aug 30, 2023 · Databases

Boost PostgreSQL Query Performance with CREATE STATISTICS: Real‑World Examples

PostgreSQL 11+ lets you define custom statistics with CREATE STATISTICS, dramatically improving query plans for large tables and complex predicates, as shown by step‑by‑step examples that cut execution time by up to 300× and illustrate different statistic kinds such as ndistinct and dependencies.

CREATE STATISTICSPostgreSQLextended statistics
0 likes · 8 min read
Boost PostgreSQL Query Performance with CREATE STATISTICS: Real‑World Examples
ITPUB
ITPUB
Aug 20, 2023 · Databases

Postgres vs MongoDB: Which Database Wins in 2023?

This article provides a comprehensive comparison between PostgreSQL and MongoDB across dimensions such as license, data model, JSON support, performance, reliability, scalability, usability, operability, and ecosystem, helping readers decide which database better fits their application requirements in 2023.

Database ComparisonLicenseMongoDB
0 likes · 11 min read
Postgres vs MongoDB: Which Database Wins in 2023?
21CTO
21CTO
Aug 18, 2023 · Databases

Why PostgreSQL Is Overtaking MySQL: Trends, Cloud Adoption, and Developer Preferences

The article examines recent data showing PostgreSQL’s rapid rise over the past decade, its strong performance in the 2023 StackOverflow survey, growing adoption by cloud providers like Google and AWS, and the reasons developers favor its open‑source reliability and extensibility.

Database trendsDeveloper SurveyMySQL
0 likes · 6 min read
Why PostgreSQL Is Overtaking MySQL: Trends, Cloud Adoption, and Developer Preferences
dbaplus Community
dbaplus Community
Aug 13, 2023 · Databases

Why Does This PostgreSQL Self‑Join Behave Unexpectedly? InitPlan & One‑Time Filter

The article examines a puzzling PostgreSQL self‑join query that yields surprising true/false results, walks through step‑by‑step rewrites, analyzes the resulting execution plans—including the appearance of InitPlan and One‑Time Filter nodes—and explains how correlated versus uncorrelated subqueries affect query evaluation.

InitPlanPostgreSQLQuery Optimization
0 likes · 11 min read
Why Does This PostgreSQL Self‑Join Behave Unexpectedly? InitPlan & One‑Time Filter
ITPUB
ITPUB
Aug 11, 2023 · Databases

Can PostgreSQL Replace Oracle in Enterprise Core Systems? Key Gaps and Challenges

The article examines why PostgreSQL still falls short of being a core enterprise database by analyzing eight technical gaps—such as XID64 support, LWLOCK efficiency, shared buffer performance, recovery, high availability, zero data loss, resource management, and CBO optimizer maturity—while reflecting on industry trends and Oracle's dominance.

Database PerformanceEnterprise DatabasesOracle Comparison
0 likes · 10 min read
Can PostgreSQL Replace Oracle in Enterprise Core Systems? Key Gaps and Challenges
Test Development Learning Exchange
Test Development Learning Exchange
Aug 7, 2023 · Databases

Python Code Examples for Connecting to Common Databases

This article provides concise Python code snippets for connecting to and querying a variety of popular databases—including MySQL, PostgreSQL, SQLite, MongoDB, Oracle, SQL Server, Redis, Elasticsearch, Cassandra, Couchbase, Firebase, DynamoDB, Neo4j, and InfluxDB—illustrating the essential steps for each.

DatabaseMongoDBMySQL
0 likes · 8 min read
Python Code Examples for Connecting to Common Databases
dbaplus Community
dbaplus Community
Aug 6, 2023 · Databases

Why UUIDs Can Hurt PostgreSQL Performance and When to Use Them

This article examines the drawbacks of using UUIDs as primary keys in PostgreSQL—highlighting WAL and index bloat, performance penalties, benchmark comparisons with sequences, and suggests ordered UUID alternatives for better scalability and maintainability.

Index BloatPostgreSQLSequential UUID
0 likes · 9 min read
Why UUIDs Can Hurt PostgreSQL Performance and When to Use Them
dbaplus Community
dbaplus Community
Jul 23, 2023 · Databases

Postgres vs MySQL: Which Database Wins in 2023?

A detailed 2023 comparison of PostgreSQL and MySQL examines licensing, performance, features, extensibility, usability, connection models, ecosystem, and operability, helping developers decide which open‑source relational database best fits their workloads and long‑term strategy.

Database ComparisonMySQLPostgreSQL
0 likes · 9 min read
Postgres vs MySQL: Which Database Wins in 2023?
21CTO
21CTO
Jul 23, 2023 · Databases

PostgreSQL vs MySQL 2023: In‑Depth Feature, Performance, and Ecosystem Comparison

This article compares PostgreSQL and MySQL across licensing, performance, features, scalability, security, query optimization, replication, JSON support, CTEs, window functions, and ecosystem, using data from the 2023 Stack Overflow survey and practical experience to help developers choose the right open‑source relational database.

Database ComparisonLicensingMySQL
0 likes · 11 min read
PostgreSQL vs MySQL 2023: In‑Depth Feature, Performance, and Ecosystem Comparison
Top Architect
Top Architect
Jul 6, 2023 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on HikariCP's pool‑sizing guidance, explaining why smaller database connection pools often yield better performance, presenting real‑world benchmark data for various pool sizes, and offering a simple formula to calculate an optimal pool size based on CPU cores and effective disks.

Connection PoolHikariCPPostgreSQL
0 likes · 10 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
Architects Research Society
Architects Research Society
Jul 2, 2023 · Databases

PostgreSQL Full-Text Search vs Elasticsearch: Performance Comparison and Findings

This article compares PostgreSQL and Elasticsearch for full‑text search in Django applications, presenting performance benchmarks on up to 1.5 million records, discussing setup complexity, features like stemming and fuzziness, and concluding that PostgreSQL is preferable for most projects without massive data scales.

DjangoElasticsearchFull-text Search
0 likes · 7 min read
PostgreSQL Full-Text Search vs Elasticsearch: Performance Comparison and Findings
Programmer DD
Programmer DD
Jun 25, 2023 · Databases

Process vs Thread Model in PostgreSQL: Benefits, Drawbacks, and Future Proposal

The article examines PostgreSQL's traditional process‑oriented architecture, compares it with a proposed thread‑based model, outlines the advantages and disadvantages of each, and discusses community perspectives on transitioning to threads for improved performance and resource efficiency.

Database ArchitecturePostgreSQLProcess Model
0 likes · 6 min read
Process vs Thread Model in PostgreSQL: Benefits, Drawbacks, and Future Proposal
21CTO
21CTO
Jun 15, 2023 · Databases

Why PostgreSQL Is Overtaking MySQL in the 2023 Developer Survey

An analysis of the 2023 Stack Overflow Developer Survey of 90,000 respondents reveals PostgreSQL surpassing MySQL as the preferred database, highlights shifting language popularity, emerging cloud platforms, and growing yet cautious adoption of AI tools among developers.

2023Database trendsDeveloper Survey
0 likes · 6 min read
Why PostgreSQL Is Overtaking MySQL in the 2023 Developer Survey
Architects Research Society
Architects Research Society
Apr 28, 2023 · Databases

High‑Availability Cluster Solutions for PostgreSQL

This article explains high‑availability concepts for PostgreSQL, reviews standby database types, describes clustering models, and evaluates several HA solutions such as DRBD, ClusterControl, Rubyrep, Pgpool II, Bucardo, Postgres‑XC, Citus, and PostgresXL, while noting practical considerations and trade‑offs.

ClusteringDatabase ReplicationHA Solutions
0 likes · 10 min read
High‑Availability Cluster Solutions for PostgreSQL