Skip to content
Tagged articles

PostgreSQL

500 articles · Page 3 of 5
IT Xianyu
IT Xianyu
Apr 24, 2025 · Databases

PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening

This tutorial explains why DBAs need security hardening and log analysis, shows how to configure minimal‑privilege roles and precise permissions in PostgreSQL, demonstrates how to detect and revoke redundant privileges, and provides a step‑by‑step guide to installing and using pgBadger for log analysis and automated reporting.

DBADatabase SecurityPermission Management
0 likes · 8 min read
PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening
ITPUB
ITPUB
Apr 19, 2025 · Databases

Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation

This article showcases a spectacular PostgreSQL query that implements the classic Tetris game using recursive CTEs, provides the full source code, highlights a known long‑run disk‑usage issue, and then presents several other impressive SQL snippets and a concise checklist for writing high‑quality SQL.

PostgreSQLRecursive CTESQL
0 likes · 25 min read
Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation
Java Tech Enthusiast
Java Tech Enthusiast
Apr 9, 2025 · Databases

MySQL vs PostgreSQL Performance Benchmark: Latency, Throughput, and Saturation

The benchmark comparing MySQL 9.0 and PostgreSQL 17.0 shows PostgreSQL consistently achieving lower insertion latency, roughly double the throughput (≈19 k QPS vs 10 k QPS), using less CPU, memory and disk I/O, while both hit an 80‑connection pool limit and PostgreSQL maintains stable read latency as MySQL’s performance degrades beyond ~5.5 k QPS.

PostgreSQLlatencymysql
0 likes · 7 min read
MySQL vs PostgreSQL Performance Benchmark: Latency, Throughput, and Saturation
Java Tech Enthusiast
Java Tech Enthusiast
Apr 8, 2025 · Databases

Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL

Choosing the proper MySQL or PostgreSQL date/time column—avoiding string types, understanding DATETIME’s literal storage versus TIMESTAMP’s automatic UTC conversion, considering PostgreSQL’s TIMESTAMP WITH/WITHOUT TIME ZONE equivalents, and weighing numeric Unix timestamps for speed—ensures correct time‑zone handling, storage efficiency, and future‑proof range.

PostgreSQLmysqltimezones
0 likes · 12 min read
Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL
Cloud Native Technology Community
Cloud Native Technology Community
Apr 2, 2025 · Databases

Three Cloud‑Native Approaches to Deploying PostgreSQL: CloudNativePG, Korifi, and Neon

The article examines three modern, cloud‑native and open‑source methods for deploying PostgreSQL—using the CloudNativePG operator on Kubernetes, leveraging Korifi’s self‑service platform, and adopting Neon’s compute‑storage separation—highlighting trends toward cloud‑native infrastructure, self‑service, and open‑source SaaS alternatives.

CloudNativePGKorifiKubernetes
0 likes · 6 min read
Three Cloud‑Native Approaches to Deploying PostgreSQL: CloudNativePG, Korifi, and Neon
IT Xianyu
IT Xianyu
Mar 24, 2025 · Databases

Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations

This article compares Oracle, PostgreSQL, and MySQL across core features, typical use cases, transaction support, storage engines, licensing, provides simplified installation steps, demonstrates basic SQL operations such as creating tables, inserting and querying data, and highlights key differences like auto‑increment handling and string‑matching functions.

OraclePostgreSQLSQL
0 likes · 7 min read
Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations
dbaplus Community
dbaplus Community
Mar 9, 2025 · Databases

Why a 2‑Billion‑Old PostgreSQL Transaction Can Crash Your Database

The article explains how PostgreSQL’s MVCC model, tuple visibility, and 32‑bit transaction ID wrap‑around can cause “sudden death” of old rows, why billions of old transactions may render data invisible, and how vacuuming and freezing prevent catastrophic database failures.

MVCCPostgreSQLTransaction ID
0 likes · 9 min read
Why a 2‑Billion‑Old PostgreSQL Transaction Can Crash Your Database
IT Services Circle
IT Services Circle
Mar 8, 2025 · Databases

PostgreSQL Overtaking MySQL: Cloud Adoption, Vector DB Advantage, and Future Database Landscape

The article analyzes recent industry data and expert observations showing PostgreSQL surpassing MySQL in cloud instance counts, CPU usage, and ecosystem support, especially in vector‑database and serverless contexts, while highlighting MySQL's strategic shortcomings and predicting PostgreSQL's dominance in the coming years.

Database TrendsPostgreSQLcloud databases
0 likes · 5 min read
PostgreSQL Overtaking MySQL: Cloud Adoption, Vector DB Advantage, and Future Database Landscape
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 27, 2025 · Databases

Boosting PostgreSQL Analytics with DuckDB: Architecture, Optimizations, and Performance Gains

This article explains how integrating DuckDB as an extension for RDS PostgreSQL creates a unified HTAP solution that dramatically accelerates complex analytical queries through columnar storage, vectorized execution, and advanced optimizer techniques, delivering up to hundreds‑fold performance improvements and superior compression.

AnalyticsColumnarDuckDB
0 likes · 11 min read
Boosting PostgreSQL Analytics with DuckDB: Architecture, Optimizations, and Performance Gains
21CTO
21CTO
Feb 9, 2025 · Databases

How Notion Scaled PostgreSQL with Database Sharding

Notion tackled severe PostgreSQL performance limits by sharding its Block table and related tables across 480 logical shards on 32 physical databases, using workspace IDs as shard keys, a dual‑write migration, and rigorous validation to achieve near‑zero downtime and faster response times.

Backend ArchitecturePostgreSQLdatabase sharding
0 likes · 7 min read
How Notion Scaled PostgreSQL with Database Sharding
Architect's Guide
Architect's Guide
Jan 17, 2025 · Databases

Understanding MySQL Multi‑Table Join Performance Compared to PostgreSQL and Query Decomposition Strategies

The article compares MySQL and PostgreSQL multi‑table join capabilities, explains why MySQL’s nested‑loop joins can be less efficient for complex queries, and discusses how decomposing joins into separate single‑table queries or moving logic to the service layer can improve performance, scalability, and caching.

Database PerformancePostgreSQLQuery Optimization
0 likes · 7 min read
Understanding MySQL Multi‑Table Join Performance Compared to PostgreSQL and Query Decomposition Strategies
Top Architect
Top Architect
Jan 12, 2025 · Backend Development

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

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, applying PostgreSQL array aggregation, moving logic to the database, and introducing Caffeine caching, with detailed code examples and performance analysis.

BackendMyBatisOptimization
0 likes · 13 min read
Optimizing a High‑Concurrency Interface: Reducing Response Time from 30 s to 0.8 s
Architecture Digest
Architecture Digest
Jan 6, 2025 · Backend Development

Optimizing Large IN Queries with Spring AOP and Multithreaded Splitting

This article explains how to improve performance of massive IN‑list queries in PostgreSQL by splitting the parameter list, executing the sub‑queries concurrently with a custom Spring AOP annotation, and merging the results using a configurable thread pool and return‑handling strategy.

AOPJavaMultithreading
0 likes · 9 min read
Optimizing Large IN Queries with Spring AOP and Multithreaded Splitting
ITPUB
ITPUB
Dec 26, 2024 · Databases

Why SELECT * Can Kill Your API Performance: Lessons from a 2012 Database Mishap

This article recounts a 2012 incident where a backend API slowed dramatically after hidden BLOB columns were added, and explains why using SELECT *—which blocks index‑only scans, forces extra I/O, increases deserialization, network, and client processing costs, and hampers schema maintenance—should be avoided in favor of explicit column lists.

Database PerformancePostgreSQLQuery Optimization
0 likes · 7 min read
Why SELECT * Can Kill Your API Performance: Lessons from a 2012 Database Mishap
Raymond Ops
Raymond Ops
Dec 21, 2024 · Databases

Why Does PostgreSQL Show “FATAL: password authentication failed for user ‘postgres’” and How to Fix It?

This guide explains why a PostgreSQL connection attempt fails with “FATAL: password authentication failed for user ‘postgres’”, outlines common causes such as wrong passwords and misconfigured postgresql.conf or pg_hba.conf, and provides step‑by‑step solutions including password reset, config correction, trust authentication and environment rebuild.

PostgreSQLconfigurationpassword-authentication
0 likes · 6 min read
Why Does PostgreSQL Show “FATAL: password authentication failed for user ‘postgres’” and How to Fix It?
Java Tech Enthusiast
Java Tech Enthusiast
Dec 17, 2024 · Databases

DBOS – Database‑Oriented Operating System

DBOS, a Database‑Oriented Operating System proposed by Matei Zaharia and Michael Stonebrake, builds the OS atop a distributed, ACID‑compliant database, storing all system and application state in tables, which simplifies scaling, ensures strong consistency, improves debugging, and reduces attack surface for cloud‑native workloads.

DBOSDistributed SystemsPostgreSQL
0 likes · 8 min read
DBOS – Database‑Oriented Operating System
21CTO
21CTO
Dec 16, 2024 · Databases

Why SELECT * Slows Down Your Database and How to Avoid It

The article recounts a 2012 incident where a seemingly fast backend API became sluggish after hidden blob columns were added, explains how SELECT * forces full table scans, extra deserialization, network overhead, and unpredictable performance, and advises selecting only needed columns for optimal efficiency.

Database PerformancePostgreSQLQuery Optimization
0 likes · 7 min read
Why SELECT * Slows Down Your Database and How to Avoid It
IT Services Circle
IT Services Circle
Dec 15, 2024 · Databases

DBOS: A Database‑Oriented Operating System for Cloud Computing

The article explains how Databricks’ scaling challenges with PostgreSQL inspired the creation of DBOS, a database‑oriented operating system that places the OS beneath a distributed transactional database to simplify task scheduling, state management, and cloud‑native workloads.

DBOSKubernetesPostgreSQL
0 likes · 9 min read
DBOS: A Database‑Oriented Operating System for Cloud Computing
IT Services Circle
IT Services Circle
Dec 5, 2024 · Databases

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer

The article explains how thousands of simultaneous client connections to a single PostgreSQL primary can cause severe write‑performance degradation, how introducing a connection pool such as pgBouncer reduces active backend processes dramatically, and why external pooling is preferred over built‑in solutions, illustrated with real‑world examples and a reference to the open‑source Pigsty distribution.

Connection PoolingPigstyPostgreSQL
0 likes · 7 min read
Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer
21CTO
21CTO
Nov 27, 2024 · Databases

Why Do the World’s Biggest Companies Choose PostgreSQL?

This article explores why leading enterprises and developers favor PostgreSQL, detailing its widespread adoption by major firms, its robust feature set, historical evolution, and how its extensibility and open‑source nature make it a compelling alternative to traditional enterprise databases.

PostgreSQLclouddatabase
0 likes · 11 min read
Why Do the World’s Biggest Companies Choose PostgreSQL?
ITPUB
ITPUB
Nov 15, 2024 · Databases

Why Vector Databases Matter: Deploying PgVector on PostgreSQL for Scalable AI Retrieval

This article explains the need for vector databases in the AI era, reviews PostgreSQL's extensible ecosystem, compares vector‑database options, provides step‑by‑step PgVector installation and usage, shares operational best practices, performance tuning tips, and real‑world Qunar & Tujia case studies.

AIPerformance TuningPostgreSQL
0 likes · 27 min read
Why Vector Databases Matter: Deploying PgVector on PostgreSQL for Scalable AI Retrieval
Linux Ops Smart Journey
Linux Ops Smart Journey
Nov 12, 2024 · Databases

Master PostgreSQL Monitoring with Grafana: Step-by-Step Guide

Learn how to deploy postgres_exporter, configure PostgreSQL extensions, set up Prometheus scraping, and create Grafana dashboards for comprehensive PostgreSQL performance monitoring, complete with command-line instructions and tips for verifying data collection and visualizing metrics.

GrafanaPostgreSQLPrometheus
0 likes · 6 min read
Master PostgreSQL Monitoring with Grafana: Step-by-Step Guide
ITPUB
ITPUB
Nov 10, 2024 · Databases

Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing

The article explains how Oracle DBAs transitioning to PostgreSQL often misinterpret work_mem and cursor sharing, showing how improper settings can drastically change execution plans, increase query time, and cause performance issues, while also highlighting differences in memory management and plan caching between the two systems.

DBAOraclePostgreSQL
0 likes · 8 min read
Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing
ITPUB
ITPUB
Nov 3, 2024 · Databases

MySQL vs PostgreSQL: Performance, Use Cases, and Choosing the Right Database

This article compares MySQL and PostgreSQL, outlining their histories, architectural differences, benchmark results for SELECT, INSERT, UPDATE operations, and discusses suitable scenarios, advantages, disadvantages, and guidance on selecting the appropriate database for various application needs.

PostgreSQLdatabase comparisonmysql
0 likes · 8 min read
MySQL vs PostgreSQL: Performance, Use Cases, and Choosing the Right Database
dbaplus Community
dbaplus Community
Oct 27, 2024 · Databases

Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts

This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.

OraclePostgreSQLbackup
0 likes · 19 min read
Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts
The Dominant Programmer
The Dominant Programmer
Oct 18, 2024 · Databases

Deploy PostgreSQL with PostGIS on CentOS using Docker Compose

This guide walks through deploying a PostgreSQL instance with the PostGIS extension on a CentOS server using Docker Compose, covering image retrieval, docker‑compose configuration, environment variables, logging settings, container startup, and verification of PostGIS integration.

CentOSPostGISPostgreSQL
0 likes · 5 min read
Deploy PostgreSQL with PostGIS on CentOS using Docker Compose
ITPUB
ITPUB
Oct 12, 2024 · Databases

How Do Chinese Databases Stack Up? A Deep Dive into Compatibility Across Major Products

This article examines the compatibility landscape of major Chinese database products, comparing their support for Oracle, MySQL, PostgreSQL and other standards, and outlines the available assessment and migration tools to help users choose the right solution for heterogeneous environments.

Chinese databasesDatabase CompatibilityMigration Tools
0 likes · 25 min read
How Do Chinese Databases Stack Up? A Deep Dive into Compatibility Across Major Products
ITPUB
ITPUB
Oct 8, 2024 · Databases

Why ON COMMIT DELETE ROWS Temp Tables Can Cripple PostgreSQL Performance

Using many ON COMMIT DELETE ROWS temporary tables in PostgreSQL can cause severe performance degradation and lock contention due to large temp_buffers, unnecessary catalog bloat, and costly truncation loops, especially in older versions or Greenplum forks.

ON COMMITPostgreSQLTemporary tables
0 likes · 10 min read
Why ON COMMIT DELETE ROWS Temp Tables Can Cripple PostgreSQL Performance
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.

PostgreSQLSQL/JSONdatabase
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.

PostgreSQLSLRU CacheSQL/JSON
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.

HashListPartitioning
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
Qunar Tech Salon
Qunar Tech Salon
Aug 28, 2024 · Databases

Why Vector Databases Are Needed, PgVector Installation, Usage, and Operational Practices in PostgreSQL

This article explains the necessity of vector databases for AI workloads, reviews the PostgreSQL ecosystem, compares vector database options, provides detailed PgVector installation and usage steps, shares operational best‑practices, performance tuning tips, and real‑world deployment cases at Qunar and Tujia.

AIPerformance TuningPostgreSQL
0 likes · 24 min read
Why Vector Databases Are Needed, PgVector Installation, Usage, and Operational Practices in PostgreSQL
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.

PostgreSQLReadySetSQL Caching
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 RepairKubernetesPostgreSQL
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.

GraphQLPostgreSQLbackend development
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.

OraclePostgreSQLdatabase backup
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.

CaffeineMyBatisPerformance Tuning
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 MigrationJavaPostgreSQL
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.

JavaPostgreSQLSQL Optimization
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.

CaffeineJavaPerformance Optimization
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.

LinuxMaster‑SlavePostgreSQL
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.

BSONBenchmarkDatabase Performance
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.

Performance TuningPostgreSQLSQL
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.

Full-Stack DevelopmentLinuxPostgreSQL
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-EnginesHeatWaveOracle
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.

PostgreSQLSQLdatabase comparison
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 ManagementExtensibilityOpen source databases
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.

ClusterCorosyncHigh Availability
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.

ChinaPostgreSQLdatabase comparison
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.

JTSJavaPostgreSQL
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.

ACIDLinux InstallationPostgreSQL
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.

OLAPPostgreSQLdatabase
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.

AWSBackendInstagram
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.

PostgreSQLdatabase comparisonmysql
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.

PostgreSQLSQLdata replication
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/CDDataRecoveryIncidentManagement
0 likes · 10 min read
What Caused Linear’s Massive Data Loss and How They Recovered It
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 OSPostgreSQL
0 likes · 11 min read
What Michael Stonebraker’s 80-Year Journey Teaches About Modern Databases
Hacker Afternoon Tea
Hacker Afternoon Tea
Dec 25, 2023 · Databases

Using PostgreSQL 16.1 and Citus 12.1 for Distributed Sharding Across Multiple Microservices

This tutorial walks through setting up a PostgreSQL 16.1 + Citus 12.1 cluster with Docker, creating separate schemas and roles for user, time, and ping microservices, distributing them via schema‑based sharding, and demonstrating CRUD operations and verification of data placement across three worker nodes.

CitusPostgreSQLdistributed database
0 likes · 12 min read
Using PostgreSQL 16.1 and Citus 12.1 for Distributed Sharding Across Multiple Microservices
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.

ContainerizationPostgreSQLdocker
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.

KubernetesPostgreSQLcontainers
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 PopularityPostgreSQL
0 likes · 9 min read
Why MySQL Still Beats PostgreSQL in China: A Deep Dive