Skip to content
Tagged articles

PostgreSQL

500 articles · Page 2 of 5
Architect's Guide
Architect's Guide
Feb 3, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits

Amid rising demand for open‑source, self‑controlled databases in China, major firms such as Tencent, Alibaba, and Huawei have built PostgreSQL‑based distributed, cloud‑native solutions, citing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, and true open‑source licensing as decisive advantages over MySQL.

PostgreSQLdatabase comparisonextensions
0 likes · 10 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits
Java Companion
Java Companion
Feb 1, 2026 · Databases

How I Completed a 100+ Table Migration in One Month Using Navicat Tricks

In under a month the author migrated more than 100 heterogeneous tables from MySQL and MongoDB to PostgreSQL across isolated networks by automating Navicat's import/export logic, streaming data, handling special characters, configuring flexible sync strategies, and using OSS as a bridge to avoid OOM and lock‑contention.

MongoDBNavicatOSS
0 likes · 20 min read
How I Completed a 100+ Table Migration in One Month Using Navicat Tricks
DevOps Coach
DevOps Coach
Jan 31, 2026 · Databases

7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance

The article reveals seven common PostgreSQL architectural oversights—such as neglecting vacuum, misusing UUID primary keys, treating the database as a queue, missing indexes, over‑relying on ORMs, ignoring write‑side scaling, and failing to partition large tables—that silently degrade performance and reliability, and provides concrete fixes and best‑practice configurations.

IndexingORMPartitioning
0 likes · 7 min read
7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance
ITPUB
ITPUB
Jan 31, 2026 · Databases

How OpenAI Scaled PostgreSQL to Support 800 Million Users and Millions of QPS

OpenAI’s engineering team expanded a single‑primary PostgreSQL cluster with nearly 50 read‑only replicas, migrated write‑heavy workloads to Azure Cosmos DB, and applied extensive optimizations to reliably serve the global traffic of ChatGPT and the OpenAI API for 800 million users at multi‑million queries per second.

AzureHigh AvailabilityPostgreSQL
0 likes · 24 min read
How OpenAI Scaled PostgreSQL to Support 800 Million Users and Millions of QPS
macrozheng
macrozheng
Jan 27, 2026 · Databases

Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison

This article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequences, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while also acknowledging MySQL's strengths in simplicity and read‑heavy web workloads.

PostgreSQLcomparisonextensions
0 likes · 9 min read
Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison
AI Engineering
AI Engineering
Jan 24, 2026 · Databases

Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked

OpenAI runs a single primary PostgreSQL with about 50 replicas to serve roughly 800 million ChatGPT users, employing PgBouncer connection pooling, cache‑lock mechanisms, query and schema optimizations, workload isolation, multi‑layer throttling, and cascade replication, while acknowledging the architecture’s limits and the complexity of full sharding.

Azure CosmosDBCascade ReplicationOpenAI
0 likes · 8 min read
Can One PostgreSQL Instance Power 800 Million Users? OpenAI’s Trade‑offs Unpacked
Radish, Keep Going!
Radish, Keep Going!
Jan 23, 2026 · Databases

How OpenAI Really Scaled PostgreSQL for Hundreds of Millions of Users

The article debunks OpenAI's sensational claim of handling 800 million ChatGPT users with a single PostgreSQL instance, revealing a pragmatic hybrid architecture that combines many read replicas, Azure CosmosDB for write‑heavy workloads, and top‑tier hardware, while highlighting cost and complexity considerations.

Azure CosmosDBPostgreSQLRead Replicas
0 likes · 6 min read
How OpenAI Really Scaled PostgreSQL for Hundreds of Millions of Users
java1234
java1234
Jan 20, 2026 · Databases

Why Do Some Projects Still Choose MySQL Over PostgreSQL?

The article compares PostgreSQL and MySQL, detailing PostgreSQL’s richer data types, true sequence support, extensible ecosystem, advanced monitoring and replication features, while also acknowledging MySQL’s simplicity and strong points, to help readers decide which database fits their workload best.

MVCCPostgreSQLdatabase comparison
0 likes · 9 min read
Why Do Some Projects Still Choose MySQL Over PostgreSQL?
Architect's Tech Stack
Architect's Tech Stack
Jan 19, 2026 · Databases

Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why major Chinese cloud providers and enterprises are building PostgreSQL‑based distributed, cloud‑native databases instead of MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced replication, licensing advantages, and MVCC implementation, while also noting MySQL's remaining strengths.

PostgreSQLdata typesdatabase comparison
0 likes · 10 min read
Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
dbaplus Community
dbaplus Community
Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

OptimizationPostgreSQLSQL
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Java Companion
Java Companion
Jan 18, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, true sequence support, powerful extensions, built‑in monitoring, advanced replication, open‑source licensing, and MVCC implementation, while acknowledging MySQL's strengths in quick deployment and read‑heavy workloads.

MVCCPostgreSQLdatabase comparison
0 likes · 10 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jan 13, 2026 · Databases

Turn PostgreSQL into a Graph Database with Apache AGE

This guide explains how Apache AGE extends PostgreSQL with OpenCypher‑compatible graph capabilities, covering architecture, installation, storage schema, Cypher‑SQL integration, common graph operations, and a LangChain example that turns natural‑language questions into executable graph queries.

Apache AGECypherLangChain
0 likes · 11 min read
Turn PostgreSQL into a Graph Database with Apache AGE
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

GISJSONBPostgreSQL
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
Ray's Galactic Tech
Ray's Galactic Tech
Jan 2, 2026 · Databases

How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs

PostgreSQL offers four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—each preventing specific concurrency anomalies like dirty reads, non‑repeatable reads, and phantom reads, and the article explains their behavior, configuration commands, practical usage, performance trade‑offs, and production best practices.

ConcurrencyPostgreSQLSQL
0 likes · 9 min read
How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs
Ray's Galactic Tech
Ray's Galactic Tech
Dec 30, 2025 · Databases

When to Combine PostgreSQL and MongoDB: A Practical Guide for Enterprise Architecture

This article explains why modern enterprises should avoid single‑database solutions, compares PostgreSQL and MongoDB across core philosophy, technical capabilities, ecosystem extensions, and cost, and provides a decision framework, real‑world case studies, and a hybrid architecture blueprint for scalable, low‑risk systems.

MongoDBPostgreSQLhybrid architecture
0 likes · 9 min read
When to Combine PostgreSQL and MongoDB: A Practical Guide for Enterprise Architecture
Ray's Galactic Tech
Ray's Galactic Tech
Dec 29, 2025 · Databases

Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide

An in‑depth enterprise guide explains why backup and replication are critical for PostgreSQL, compares physical, logical, and logical replication methods, provides step‑by‑step command examples, outlines high‑availability architectures, automation scripts, disaster‑recovery procedures, monitoring queries, and common pitfalls to ensure robust data protection.

High AvailabilityPostgreSQLdisaster recovery
0 likes · 8 min read
Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide
ITPUB
ITPUB
Dec 29, 2025 · Databases

Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25

VectorChord‑BM25 is a PostgreSQL extension that adds native BM25 ranking and tokenization, delivering up to three‑fold query‑per‑second improvements over ElasticSearch while maintaining comparable relevance scores, and includes detailed installation, usage examples, and performance analysis.

BM25PostgreSQLRanking
0 likes · 17 min read
Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25
Alibaba Cloud Observability
Alibaba Cloud Observability
Dec 29, 2025 · Cloud Native

How Alibaba Cloud Log Service Supercharges Dify’s Scaling and Cuts DB Costs

This article examines Dify’s production‑scale bottlenecks caused by heavy PostgreSQL logging, explains why a cloud‑native log service (SLS) better matches the append‑only, high‑throughput nature of workflow logs, and provides a step‑by‑step migration guide that dramatically reduces database pressure, storage cost, and unlocks advanced analytics.

Alibaba Cloud Log ServiceCloud NativeDify
0 likes · 17 min read
How Alibaba Cloud Log Service Supercharges Dify’s Scaling and Cuts DB Costs
Top Architect
Top Architect
Dec 29, 2025 · Databases

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why leading Chinese tech firms are increasingly adopting PostgreSQL instead of MySQL, detailing PostgreSQL‑based products, comparing data‑type support, sequence handling, extensions, monitoring tools, replication mechanisms, licensing, community openness, and MVCC implementation, while also outlining MySQL's limitations.

PostgreSQLSQLdatabase comparison
0 likes · 11 min read
Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
DevOps Coach
DevOps Coach
Dec 26, 2025 · Databases

Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding

The article recounts how a PostgreSQL instance on a modest 2‑CPU, 4 GB VM handling 1.2 billion rows was dramatically accelerated by adding BRIN indexes, scheduling maintenance with pg_cron, applying query folding and tuning memory and parallel settings, achieving sub‑second query times without additional hardware.

BRIN IndexPartitioningPerformance Tuning
0 likes · 9 min read
Achieving Sub‑Second Queries on 1.2 B‑Row PostgreSQL Using BRIN, pg_cron & Query Folding
Ray's Galactic Tech
Ray's Galactic Tech
Dec 26, 2025 · Databases

Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops

This comprehensive guide explains PostgreSQL's Write-Ahead Logging (WAL) fundamentals, its role in durability, crash recovery, PITR and streaming replication, details the checkpoint mechanism, essential monitoring queries, production‑grade configuration recommendations, backup and recovery procedures, and practical DBA checklists for reliable operations.

PostgreSQLWALdatabase administration
0 likes · 7 min read
Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops
Data STUDIO
Data STUDIO
Dec 23, 2025 · Databases

Is the Vector Database Dead? PostgreSQL’s New pgvector Feature Puts Closed‑Source Solutions on the Spot

The article examines how PostgreSQL’s latest pgvector 0.8.0 release adds iterative index scans and smart query planning, enabling fully free vector search within an existing relational database, compares performance, cost, and architecture against dedicated vector databases like Pinecone, and outlines migration steps and best‑practice guidelines.

AIBenchmarkPostgreSQL
0 likes · 14 min read
Is the Vector Database Dead? PostgreSQL’s New pgvector Feature Puts Closed‑Source Solutions on the Spot
FunTester
FunTester
Dec 21, 2025 · Backend Development

Why River Is the Go‑Friendly Queue That Guarantees Transactional Consistency

This article explains how the River library leverages PostgreSQL to provide a Go‑native job queue with true transactional guarantees, high concurrency via goroutines, and efficient scheduling using SKIP LOCKED, while offering step‑by‑step setup and code examples for rapid adoption.

@TransactionalConcurrencyGo
0 likes · 15 min read
Why River Is the Go‑Friendly Queue That Guarantees Transactional Consistency
Architect
Architect
Dec 19, 2025 · Databases

Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequence support, powerful extensions, superior monitoring and replication features, and open‑source licensing, while also noting MySQL's simplicity and ecosystem strengths, to explain why many Chinese enterprises choose PostgreSQL for their core databases.

PostgreSQLdatabase comparisonextensions
0 likes · 9 min read
Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained
Ray's Galactic Tech
Ray's Galactic Tech
Dec 16, 2025 · Databases

PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide

Choosing between PostgreSQL and MySQL isn’t just a feature checklist; it requires weighing business complexity, team expertise, and future uncertainty, with this guide offering core design philosophies, multi-dimensional capability comparisons, actionable decision paths, and real-world case studies to help you make a production-grade database choice.

GISJSONPostgreSQL
0 likes · 12 min read
PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide
Java Companion
Java Companion
Dec 16, 2025 · Databases

Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison

The article compares PostgreSQL and MySQL across data types, sequence handling, extensions, monitoring tools, replication, licensing, and MVCC implementation, showing why many Chinese tech giants prefer PostgreSQL for complex, high‑availability workloads while acknowledging MySQL’s strengths in simple web scenarios.

Feature AnalysisMVCCOpen source databases
0 likes · 8 min read
Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison
DevOps Coach
DevOps Coach
Dec 15, 2025 · Databases

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.

Database ExtensionsJSONBPostgreSQL
0 likes · 6 min read
Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming
DevOps Coach
DevOps Coach
Dec 8, 2025 · Databases

Why UUID Primary Keys Halve Your Database Throughput (And How to Fix It)

Using random UUID primary keys forces PostgreSQL to write to unpredictable index pages, causing heavy CPU usage, large index size, and dramatically higher insert latency, while switching to a sequential bigint key restores performance and reduces write amplification.

BenchmarkDatabase PerformanceIndexing
0 likes · 7 min read
Why UUID Primary Keys Halve Your Database Throughput (And How to Fix It)
dbaplus Community
dbaplus Community
Dec 7, 2025 · Databases

Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC

An in‑depth comparison of PostgreSQL and MySQL examines how primary and secondary indexes are implemented, contrasts query execution costs, explores data type impacts, explains MVCC undo logs, and discusses process versus thread architectures, highlighting performance trade‑offs for each system.

MVCCPostgreSQLQuery Optimization
0 likes · 13 min read
Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC
dbaplus Community
dbaplus Community
Dec 3, 2025 · Databases

Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights

This article compares SQLite and PostgreSQL, presents detailed SQLite version timelines and OS compatibility tables, explains the differences between rollback‑journal and WAL concurrency models, shows a simple multi‑process lock test, and concludes that SQLite 3.45 is the most suitable choice for modern Linux, macOS, Android and iOS deployments.

ConcurrencyPostgreSQLSQLite
0 likes · 14 min read
Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights
Su San Talks Tech
Su San Talks Tech
Nov 26, 2025 · Databases

Master Database Indexes: 10 Essential Questions and Best Practices

This guide explores the fundamentals of database indexing, answering ten common questions about index design, performance pitfalls, composite indexes, covering indexes, NULL handling, and maintenance, while providing practical SQL examples, B+‑tree concepts, and best‑practice recommendations for MySQL and PostgreSQL.

B+ TreeIndexingPostgreSQL
0 likes · 13 min read
Master Database Indexes: 10 Essential Questions and Best Practices
Top Architect
Top Architect
Nov 25, 2025 · Databases

MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives

With MySQL 8.0 support ending on April 30, 2026, users must migrate within six months to avoid security risks, and can choose upgrading to the latest MySQL, switching to Percona Server, or moving to alternatives like MariaDB or PostgreSQL, each with its own pros and cons.

Database MigrationEOLMariaDB
0 likes · 7 min read
MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives
Selected Java Interview Questions
Selected Java Interview Questions
Nov 20, 2025 · Databases

Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

This article examines why major Chinese technology companies are building distributed, cloud‑native and HTAP databases on PostgreSQL instead of MySQL, detailing PostgreSQL's richer data types, true sequence support, extensive extensions, superior monitoring tools, and robust replication mechanisms.

HTAPPostgreSQLdatabase comparison
0 likes · 8 min read
Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
Efficient Ops
Efficient Ops
Nov 11, 2025 · Databases

MySQL 8.0 End-of-Life 2026: Migration Paths and Best Practices

MySQL 8.0 will lose Oracle support on April 30, 2026, ending security patches, bug fixes, and official assistance, so organizations must choose between upgrading to a newer MySQL version, switching to Percona Server, or migrating to alternative databases like MariaDB or PostgreSQL.

DBaaSDatabase MigrationEnd-of-Life
0 likes · 5 min read
MySQL 8.0 End-of-Life 2026: Migration Paths and Best Practices
21CTO
21CTO
Nov 10, 2025 · Databases

MySQL vs PostgreSQL: Which Database Wins the Ingestion and Query Battle?

This article presents a detailed performance benchmark comparing MySQL 9.0 and PostgreSQL 17.0, measuring data‑ingestion latency, throughput, saturation, CPU and memory usage, as well as query efficiency, and concludes which open‑source database delivers superior write and read performance.

BenchmarkConnection PoolData Ingestion
0 likes · 10 min read
MySQL vs PostgreSQL: Which Database Wins the Ingestion and Query Battle?
Ops Community
Ops Community
Nov 5, 2025 · Databases

Mastering PostgreSQL Replication: Diagnose Lag, Split‑Brain, and Fix Common Issues

This comprehensive guide walks you through troubleshooting PostgreSQL physical (stream) replication, covering environment prerequisites, anti‑pattern warnings, step‑by‑step diagnostics for replication lag, split‑brain scenarios, replication slot problems, monitoring setup with Prometheus, and best‑practice recommendations to keep your primary‑standby cluster healthy.

PostgreSQLWALreplication
0 likes · 35 min read
Mastering PostgreSQL Replication: Diagnose Lag, Split‑Brain, and Fix Common Issues
dbaplus Community
dbaplus Community
Nov 2, 2025 · Databases

How a Simple PgBouncer Switch Saved Us $10 Million in Cloud Costs

When a sudden 38% rise in AWS bills revealed hidden connection‑storm costs in a Kubernetes‑based microservice architecture, the team introduced PgBouncer as a transaction‑pooling proxy, slashing database connections from over 14,000 to under 400 and cutting monthly cloud spend by more than $300,000, ultimately saving $10.8 million over three years.

Connection PoolingKubernetesPostgreSQL
0 likes · 9 min read
How a Simple PgBouncer Switch Saved Us $10 Million in Cloud Costs
21CTO
21CTO
Nov 2, 2025 · Databases

How to Slash Database Costs by 60% Without Sacrificing Performance

This article explains why database expenses balloon, then walks through ten practical techniques—including smart indexing, selective column queries, caching, partitioning, archiving, data‑type tuning, simplifying joins, regular maintenance, query monitoring, and right‑sized hardware—to cut costs up to 60% while preserving or even boosting query speed.

Performance TuningPostgreSQLSQL
0 likes · 10 min read
How to Slash Database Costs by 60% Without Sacrificing Performance
Ray's Galactic Tech
Ray's Galactic Tech
Oct 24, 2025 · Databases

How to Choose Between MySQL, PostgreSQL, and MongoDB: The Ultimate Guide

This comprehensive guide compares MySQL, PostgreSQL, and MongoDB across core features, transaction models, indexing, scalability, and real‑world use cases, offering a step‑by‑step selection method, detailed pros and cons, and a practical decision flowchart to help engineers pick the right database for their projects.

MongoDBNoSQLPostgreSQL
0 likes · 9 min read
How to Choose Between MySQL, PostgreSQL, and MongoDB: The Ultimate Guide
Efficient Ops
Efficient Ops
Oct 21, 2025 · Operations

Deploy n8n with Docker: Fast Setup, Production Config, and Database Guide

This guide explains what n8n is, compares it with Coze and Dify, and provides step‑by‑step instructions for quick installation via npx or Docker, detailed multi‑stage Dockerfile, production environment settings, database, SSL, Redis, monitoring, and backup strategies for reliable workflow automation.

PostgreSQLProduction DeploymentRedis
0 likes · 8 min read
Deploy n8n with Docker: Fast Setup, Production Config, and Database Guide
Architect
Architect
Oct 21, 2025 · Backend Development

Boost PostgreSQL IN Query Performance with Spring AOP SplitWork Annotation

This article explains how to improve the performance of large PostgreSQL IN queries by splitting them into smaller batches, executing them concurrently with Spring AOP and custom annotations, and then merging the results, providing a reusable solution for high‑volume database operations.

AOPIN query optimizationJava
0 likes · 11 min read
Boost PostgreSQL IN Query Performance with Spring AOP SplitWork Annotation
dbaplus Community
dbaplus Community
Oct 19, 2025 · Databases

How PostgreSQL 18 Made My Redis Cache Redundant (And What You Can Learn)

After disabling Redis in production and carefully testing on PostgreSQL 18, the author reduced p95 latency, simplified the system, and lowered operational overhead by replacing the cache with a covering index, a generated column, and a materialized view, while providing detailed query examples, configuration tweaks, and performance measurements.

IndexingMaterialized ViewPostgreSQL
0 likes · 10 min read
How PostgreSQL 18 Made My Redis Cache Redundant (And What You Can Learn)
macrozheng
macrozheng
Oct 15, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article examines why PostgreSQL is often a better choice than MySQL for high‑performance workloads, covering architectural differences, indexing capabilities, query optimization, data types, concurrency control, benchmark results, and migration considerations, and provides code examples to illustrate each point.

ConcurrencyIndexingPostgreSQL
0 likes · 13 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
IT Services Circle
IT Services Circle
Oct 14, 2025 · Databases

How to Efficiently Store IP Addresses in PostgreSQL and MySQL

This article explains how PostgreSQL and MySQL store IP addresses using native data types and functions, showing example table definitions, insertion and query statements for both IPv4 and IPv6, and highlights the advantages of using specialized types over plain VARCHAR.

INET typeIP storagePostgreSQL
0 likes · 4 min read
How to Efficiently Store IP Addresses in PostgreSQL and MySQL
Dunmao Tech Hub
Dunmao Tech Hub
Oct 13, 2025 · Backend Development

One-Click Spring Boot Deployment on Windows with Batch Scripts

Learn how to create self-contained batch scripts that initialize a PostgreSQL database, import SQL, and launch a Spring Boot JAR on Windows, enabling one‑click service startup without manual environment configuration, and see example directory layout and customization tips.

PostgreSQLSpring BootWindows deployment
0 likes · 7 min read
One-Click Spring Boot Deployment on Windows with Batch Scripts
DevOps Coach
DevOps Coach
Oct 11, 2025 · Databases

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.

Database MigrationIndex BloatPostgreSQL
0 likes · 12 min read
Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification
IT Services Circle
IT Services Circle
Oct 11, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, query optimization, data types, concurrency control, and real‑world benchmarks, showing why PostgreSQL generally outperforms MySQL in high‑throughput, complex‑query, and data‑intensive applications.

Database PerformanceIndexingPostgreSQL
0 likes · 12 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
IT Services Circle
IT Services Circle
Oct 10, 2025 · Databases

Why PostgreSQL Is Overtaking MySQL in the AI Era – A Feature Comparison

While MySQL remains a reliable, widely-used relational database for simple applications, PostgreSQL’s extensibility, AI-friendly extensions, and growing developer preference—highlighted by recent Stack Overflow surveys—make it the stronger choice for modern, complex workloads, especially those involving vector search, time‑series, and geospatial data.

AIDeveloper SurveyExtensibility
0 likes · 6 min read
Why PostgreSQL Is Overtaking MySQL in the AI Era – A Feature Comparison
Su San Talks Tech
Su San Talks Tech
Oct 9, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, complex query optimization, data‑type support, transaction handling, and real‑world benchmark results, showing why PostgreSQL is generally the better choice for high‑concurrency, data‑intensive applications.

ConcurrencyDatabase PerformanceIndexing
0 likes · 13 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
JavaGuide
JavaGuide
Oct 8, 2025 · Databases

Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?

While MySQL has long dominated relational databases with its open‑source stability and massive user base, the rise of AI and PostgreSQL’s extensible ecosystem—highlighted by extensions like pgvector, pg_bm25, TimescaleDB and PostGIS—are shifting developer preference, as shown by the 2025 Stack Overflow survey.

AIDatabase ExtensibilityPostgreSQL
0 likes · 6 min read
Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?
21CTO
21CTO
Oct 7, 2025 · Databases

What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More

PostgreSQL 18, released on September 25 2025, introduces developer‑focused features such as native UUID v7 generation, virtual generated columns, enhanced RETURNING clauses, automatic BUFFERS in EXPLAIN ANALYZE, and a unified pg_get_acl() permission function, all aimed at improving everyday database development.

Database DevelopmentEXPLAIN ANALYZEPostgreSQL
0 likes · 8 min read
What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More
IT Services Circle
IT Services Circle
Oct 3, 2025 · Databases

Why Does PostgreSQL’s B‑Tree Index Behave Like a B+ Tree?

PostgreSQL’s index system, officially called a B‑Tree, actually implements B+‑tree functionality, storing only TIDs in leaf nodes, using linked leaf pages for efficient range queries, and includes optimizations like deduplication, index‑only scans, and reverse‑key indexes to boost performance.

B+ TreeB-TreeDatabase Indexing
0 likes · 7 min read
Why Does PostgreSQL’s B‑Tree Index Behave Like a B+ Tree?
Ray's Galactic Tech
Ray's Galactic Tech
Sep 27, 2025 · Databases

Master PostgreSQL Streaming Replication: Step‑by‑Step Setup Guide

This comprehensive guide explains PostgreSQL streaming replication concepts, required environment, primary and standby configuration commands, verification queries, failover procedures, and production best‑practice recommendations, enabling you to build a reliable high‑availability database cluster.

Database ReplicationFailoverHigh Availability
0 likes · 7 min read
Master PostgreSQL Streaming Replication: Step‑by‑Step Setup Guide
21CTO
21CTO
Sep 27, 2025 · Databases

PostgreSQL 18 Unveiled: Async I/O, OAuth Security, and SQL Boosts Explained

PostgreSQL 18 introduces async I/O for faster queries, built‑in OAuth authentication, expanded SQL standard support, optimizer and extension enhancements, and tighter Kubernetes integration, delivering higher performance, stronger security, and greater flexibility for developers and DBAs tackling modern analytics, AI workloads, and distributed environments.

KubernetesOAuthPostgreSQL
0 likes · 8 min read
PostgreSQL 18 Unveiled: Async I/O, OAuth Security, and SQL Boosts Explained
Ops Development & AI Practice
Ops Development & AI Practice
Sep 25, 2025 · Databases

Master Passwordless PostgreSQL Logins: .pgpass, PGPASSWORD, and pg_hba.conf

This guide explains how to bypass interactive password prompts when using psql by configuring a per‑user .pgpass file, setting the PGPASSWORD environment variable for temporary sessions, and adjusting the server‑side pg_hba.conf file, while covering required file formats, permission settings, security trade‑offs, and best‑practice recommendations.

.pgpassDatabase SecurityPGPASSWORD
0 likes · 7 min read
Master Passwordless PostgreSQL Logins: .pgpass, PGPASSWORD, and pg_hba.conf
Ray's Galactic Tech
Ray's Galactic Tech
Sep 23, 2025 · Databases

Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide

This comprehensive guide walks you through installing PostgreSQL on Linux, Windows, macOS, and Docker, configuring users, databases, and remote access, using daily psql commands, performing backups, applying advanced features like tablespaces and replication, and optimizing performance with key tuning parameters.

Performance TuningPostgreSQLSQL
0 likes · 7 min read
Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide
21CTO
21CTO
Sep 22, 2025 · Fundamentals

What’s Driving Python’s 2025 Surge? Survey Reveals AI, Web, and Rust Trends

Based on a survey of over 30,000 Python developers, the 2025 report shows half are newcomers, AI‑assisted coding is exploding, FastAPI leads web frameworks, most still run legacy versions, Rust‑based tools gain traction, and PostgreSQL remains the dominant database, shaping Python’s future direction.

AIDeveloper SurveyFastAPI
0 likes · 11 min read
What’s Driving Python’s 2025 Surge? Survey Reveals AI, Web, and Rust Trends
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 9, 2025 · Backend Development

Why Adding 2 Days Sometimes Results in a 3-Day Unblock? Java Date Precision Explained

A Java backend bug caused blacklist unblocking times to be stored one second later than expected due to mismatched Date and TIMESTAMP precision, daylight‑saving and timezone conversions, and millisecond rounding, which was diagnosed through code review, AI analysis, and batch testing, then fixed by normalising nanoseconds or adjusting database column precision.

DATETIMEJavaPostgreSQL
0 likes · 11 min read
Why Adding 2 Days Sometimes Results in a 3-Day Unblock? Java Date Precision Explained
ITPUB
ITPUB
Sep 6, 2025 · Databases

Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed

The article explains how using OFFSET for pagination can cause severe performance degradation as data grows, and demonstrates how switching to keyset (seek) pagination, optionally combined with cursor encoding, index‑only OFFSET, or materialized views, dramatically reduces query latency.

PaginationPostgreSQLSQL
0 likes · 8 min read
Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed
Liangxu Linux
Liangxu Linux
Sep 6, 2025 · Databases

Why PostgreSQL Is Overtaking MySQL: Survey Data and Real‑World Insights

A recent Stack Overflow survey shows PostgreSQL surpassing MySQL in popularity, and the article explains the technical advantages, real‑world performance tests, and evolving use cases that make PostgreSQL the preferred choice for many developers while still acknowledging MySQL’s enduring role for beginners.

PostgreSQLSQLdata analysis
0 likes · 5 min read
Why PostgreSQL Is Overtaking MySQL: Survey Data and Real‑World Insights
Architecture Digest
Architecture Digest
Sep 5, 2025 · Backend Development

Migrate SpringBoot MySQL to PostgreSQL: Step‑by‑Step Guide & Common Pitfalls

This tutorial walks through converting a SpringBoot + MybatisPlus application from MySQL to PostgreSQL, covering driver addition, JDBC configuration, schema differences, numerous SQL incompatibilities, transaction quirks, and provides helper scripts for bulk type changes and default timestamp settings, while highlighting practical solutions.

PostgreSQLmigration
0 likes · 11 min read
Migrate SpringBoot MySQL to PostgreSQL: Step‑by‑Step Guide & Common Pitfalls
Cognitive Technology Team
Cognitive Technology Team
Aug 24, 2025 · Databases

When Auto‑Increment IDs Exhaust: Risks and Scalable Solutions for MySQL & PostgreSQL

This article examines how auto‑increment primary keys work, the limits of common integer types, the failures that occur when those limits are reached, and practical strategies—including type upgrades, distributed ID generators, sharding, and sequence cycling—to prevent and mitigate ID exhaustion in high‑traffic MySQL and PostgreSQL deployments.

PostgreSQLPrimary Keyauto-increment
0 likes · 9 min read
When Auto‑Increment IDs Exhaust: Risks and Scalable Solutions for MySQL & PostgreSQL
ITPUB
ITPUB
Aug 15, 2025 · Databases

Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC Differences

This article compares PostgreSQL and MySQL by examining their index structures, query execution costs, data‑type impacts, undo‑log mechanisms, and process models, highlighting where each system excels or falls short in real‑world workloads.

MVCCPostgreSQLQuery Optimization
0 likes · 13 min read
Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC Differences
dbaplus Community
dbaplus Community
Aug 14, 2025 · Databases

10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them

Discover the ten most frequent causes of sluggish PostgreSQL queries—from missing or inefficient indexes and poor query design to lack of vacuuming, table bloat, wrong data types, excessive sequential scans, deadlocks, missing connection pooling, overused ORDER BY/DISTINCT, and misconfigured settings—and learn concrete steps to resolve each issue.

PostgreSQLQuery OptimizationVACUUM
0 likes · 6 min read
10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them
macrozheng
macrozheng
Aug 5, 2025 · Databases

Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide

This guide walks you through converting a SpringBoot + MyBatisPlus project from MySQL to PostgreSQL, covering driver setup, JDBC configuration changes, common SQL syntax pitfalls, and provides helper scripts for bulk column adjustments and default value settings.

Database MigrationJDBCPostgreSQL
0 likes · 12 min read
Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide
JakartaEE China Community
JakartaEE China Community
Jul 28, 2025 · Backend Development

How to Store JSON Data Using JPA and Hibernate

This tutorial shows how to store, query, and manipulate JSON data in PostgreSQL using JPA and Hibernate, covering native JSON/JSONB types, the Hypersistence JsonType, entity mapping, service and REST layers, WildFly configuration, and curl‑based testing.

HibernateHypersistenceJPA
0 likes · 11 min read
How to Store JSON Data Using JPA and Hibernate
IT Xianyu
IT Xianyu
Jul 22, 2025 · Databases

Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes

This guide walks you through using JetBrains DataGrip on AlmaLinux to connect to a PostgreSQL server, then demonstrates step‑by‑step how to insert, modify, and delete records via the graphical interface and optional SQL console, highlighting key settings and safety tips.

AlmaLinuxCRUDDataGrip
0 likes · 10 min read
Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes
IT Xianyu
IT Xianyu
Jul 21, 2025 · Databases

Deploy PostgreSQL on AlmaLinux with Docker Compose in One Click

This guide walks you through installing Docker and Docker Compose on AlmaLinux, creating a concise docker‑compose.yml to run PostgreSQL in an isolated container, connecting with DataGrip, and managing the lifecycle of the database service with simple commands.

AlmaLinuxContainerizationDataGrip
0 likes · 11 min read
Deploy PostgreSQL on AlmaLinux with Docker Compose in One Click
Code Mala Tang
Code Mala Tang
Jul 3, 2025 · Databases

How We Achieved 50,000 TPS with PostgreSQL & Node.js: 6 Proven Optimizations

By systematically applying connection pooling, batch processing, WAL tuning, table partitioning, query refactoring, and OS-level tweaks, we transformed a PostgreSQL‑Node.js stack to sustain 50,000 transactions per second with sub‑100 ms latency, while maintaining data consistency on modest hardware.

Node.jsPostgreSQLdatabase tuning
0 likes · 10 min read
How We Achieved 50,000 TPS with PostgreSQL & Node.js: 6 Proven Optimizations
21CTO
21CTO
Jul 1, 2025 · Databases

Why a 20‑Year‑Old MySQL Bug Still Threatens Data Integrity

A two‑decade‑old MySQL bug (bug 11472) that prevents triggers from firing on cascading foreign‑key updates has remained unfixed, sparking community frustration, debates over ACID compliance, and a shift toward alternatives like PostgreSQL in modern applications.

ACIDDatabase BugPostgreSQL
0 likes · 5 min read
Why a 20‑Year‑Old MySQL Bug Still Threatens Data Integrity
IT Xianyu
IT Xianyu
Jun 26, 2025 · Databases

Master DataGrip: Connect MySQL & PostgreSQL Quickly with Step‑by‑Step Guide

This tutorial walks you through preparing your environment, configuring DataGrip, and executing SQL scripts to connect and manage both MySQL and PostgreSQL databases, complete with hardware requirements, connection parameters, sample code, troubleshooting tips, and performance optimization advice.

DataGripIDEPostgreSQL
0 likes · 8 min read
Master DataGrip: Connect MySQL & PostgreSQL Quickly with Step‑by‑Step Guide
IT Xianyu
IT Xianyu
Jun 22, 2025 · Databases

Master Looping and Variables in MySQL & PostgreSQL Stored Procedures

This tutorial demonstrates how to use variables and loop constructs in MySQL and PostgreSQL stored procedures to iterate over a users table, filter records by age, and simulate sending a system welcome message, while comparing syntax differences between the two databases.

LoopPostgreSQLSQL
0 likes · 6 min read
Master Looping and Variables in MySQL & PostgreSQL Stored Procedures
ITPUB
ITPUB
Jun 3, 2025 · Databases

Why Snowflake Is Buying Crunchy Data – Inside the AI Data Cloud Strategy

Snowflake's $2.5 billion acquisition of Crunchy Data aims to embed PostgreSQL into its AI Data Cloud, launching a managed Snowflake Postgres service that fuels the emerging Agentic AI era while positioning the company against rivals like Databricks and Salesforce in the data‑infrastructure race.

AI Data CloudAgentic AICrunchy Data
0 likes · 10 min read
Why Snowflake Is Buying Crunchy Data – Inside the AI Data Cloud Strategy
ITPUB
ITPUB
May 25, 2025 · Databases

MySQL vs PostgreSQL: Which Database Handles High‑Throughput Writes Faster?

A detailed benchmark comparing MySQL 9.0 and PostgreSQL 17.0 evaluates ingestion latency, throughput, saturation, and connection‑pool behavior, revealing that PostgreSQL consistently delivers lower write latency, higher QPS, better CPU and memory efficiency, and superior disk storage efficiency across both write and read workloads.

Connection PoolDatabase IngestionPostgreSQL
0 likes · 9 min read
MySQL vs PostgreSQL: Which Database Handles High‑Throughput Writes Faster?
IT Xianyu
IT Xianyu
May 14, 2025 · Databases

Using PostgreSQL Stored Procedures to Batch Update User Tags Efficiently

This article explains how Java developers can replace thousands of individual UPDATE statements with a single PostgreSQL stored procedure call, covering the motivation, procedure creation, Java invocation, scheduling with shell scripts, performance benchmarks, and common pitfalls.

Batch UpdateJavaPostgreSQL
0 likes · 8 min read
Using PostgreSQL Stored Procedures to Batch Update User Tags Efficiently
macrozheng
macrozheng
May 13, 2025 · Backend Development

Why Supabase Is the Ultimate Open‑Source Backend for Rapid App Development

This article introduces Supabase, an open‑source Firebase alternative built on PostgreSQL that offers RESTful and GraphQL APIs, real‑time data sync, authentication, and serverless functions, and provides step‑by‑step guidance for cloud‑hosted or local deployment to accelerate backend development.

PostgreSQLReal-time APISupabase
0 likes · 7 min read
Why Supabase Is the Ultimate Open‑Source Backend for Rapid App Development
Top Architect
Top Architect
May 10, 2025 · Backend Development

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

This article presents a real‑world case study of a high‑traffic backend API that originally took 30 seconds to process over two million records, detailing problem diagnosis, SQL and Java code analysis, and a series of optimizations—including SQL rewrites, database‑side aggregation, and Caffeine caching—that ultimately cut the response time to under one second.

BackendCaffeine CacheMyBatis
0 likes · 13 min read
Optimizing a High‑Concurrency Backend Interface: Reducing Response Time from 30 seconds to 0.8 seconds
Film Hurricane Tech Team
Film Hurricane Tech Team
May 2, 2025 · Databases

Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons

The article details how DaVinci Resolve’s project library, built on PostgreSQL, evolved from a monolithic server to a Docker‑based setup and finally to a Pigsty‑powered high‑availability cluster, covering challenges, point‑in‑time recovery, permission management, a real‑world outage, and the resulting reliability gains.

DaVinci ResolveDatabase MigrationHigh Availability
0 likes · 6 min read
Scaling DaVinci Resolve’s Database to Millions of Projects: Evolution and Lessons
Wukong Talks Architecture
Wukong Talks Architecture
Apr 28, 2025 · Databases

Comprehensive Guide to Popular Database Management Tools

This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.

DBeaverDatabase ToolsNavicat
0 likes · 19 min read
Comprehensive Guide to Popular Database Management Tools