Skip to content
Tagged articles

PostgreSQL

500 articles · Page 4 of 5
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.

Cloud NativeHigh AvailabilityKubernetes
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.

PostgreSQLSQLdata types
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-EnginesPostgreSQLTPC-C
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 PopularityLAMP
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.

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

MVCCPostgreSQLTransaction
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-EnginesMVCCPostgreSQL
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.

DBaaSEOLPostgreSQL
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 UpgradePostgreSQL
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.

JSONLicenseMongoDB
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 SurveyPostgreSQL
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.

Code ExamplesMongoDBPostgreSQL
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.

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

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

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

PostgreSQLProcess Modeldatabase architecture
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.

Database ReplicationHA SolutionsPostgreSQL
0 likes · 10 min read
High‑Availability Cluster Solutions for PostgreSQL
ITPUB
ITPUB
Apr 24, 2023 · Databases

Master PostgreSQL Performance: From Hardware to Query Tuning

Effective PostgreSQL performance tuning requires a holistic approach, covering hardware sizing, OS sysctl tweaks, filesystem choices, query and schema design, key PostgreSQL parameters, concurrency settings, cache management, and careful scheduling of automated maintenance tasks to avoid resource conflicts.

OS ConfigurationPerformance TuningPostgreSQL
0 likes · 10 min read
Master PostgreSQL Performance: From Hardware to Query Tuning
ITPUB
ITPUB
Apr 22, 2023 · Databases

Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates

The article examines why PostgreSQL tables often retain large disk footprints after massive inserts, updates, and deletions, showing experiments on PG 13/PG 14, analyzing factors such as long‑running transactions, replication slots, uncommitted transactions, fillfactor settings, and the old_snapshot_threshold bug, and offering practical diagnostics and mitigation steps.

PostgreSQLVACUUMfillfactor
0 likes · 8 min read
Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates
MaGe Linux Operations
MaGe Linux Operations
Apr 10, 2023 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, how to create connections for databases like PostgreSQL via JDBC, and how to generate ER diagrams from existing schemas, all illustrated with step‑by‑step screenshots.

DBeaverER diagramJDBC
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly
ITPUB
ITPUB
Mar 8, 2023 · Databases

Why Cloud Migration Won’t Make DBAs Obsolete – New Roles and Challenges

Moving databases to the cloud changes DBA tasks but does not eliminate the role; it introduces new responsibilities such as migration planning, cross‑cloud compatibility, performance tuning, and acting as a bridge between cloud providers and enterprises.

DBAPostgreSQLcloud databases
0 likes · 10 min read
Why Cloud Migration Won’t Make DBAs Obsolete – New Roles and Challenges
Ops Development Stories
Ops Development Stories
Mar 6, 2023 · Databases

How to Deploy and Use Bytebase for Database CI/CD on Kubernetes

This guide explains why traditional DBA tasks are tedious, introduces Bytebase as a reliable database CI/CD platform, and provides step‑by‑step instructions for deploying Bytebase and PostgreSQL on Kubernetes, configuring GitLab integration, managing users, instances, projects, environments, and performing schema changes and data operations.

BytebaseDatabase CI/CDDevOps
0 likes · 11 min read
How to Deploy and Use Bytebase for Database CI/CD on Kubernetes
ITPUB
ITPUB
Feb 27, 2023 · Databases

Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases

This article explains why SQL join execution plans often cause severe performance drops after moving from Oracle to domestic or open‑source databases, demonstrates each join type with PostgreSQL examples, shows how plan choices like HASH JOIN versus NESTED LOOP affect speed, and offers rewrite techniques such as NOT EXISTS or UNION to restore efficiency.

Database MigrationOptimizationOracle
0 likes · 8 min read
Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases
21CTO
21CTO
Feb 18, 2023 · Databases

MySQL vs PostgreSQL 2023: Which Database Should You Choose?

This 2023 comparison examines MySQL and PostgreSQL across history, features, performance, scalability, cost, and migration trends, helping developers decide which relational database best fits their specific application requirements.

2023PostgreSQLRDBMS
0 likes · 13 min read
MySQL vs PostgreSQL 2023: Which Database Should You Choose?
dbaplus Community
dbaplus Community
Feb 14, 2023 · Databases

10 Common PostgreSQL Mistakes and How to Avoid Them

This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.

Connection PoolingIndexingPerformance Tuning
0 likes · 16 min read
10 Common PostgreSQL Mistakes and How to Avoid Them
ITPUB
ITPUB
Feb 6, 2023 · Artificial Intelligence

Can ChatGPT Replace a DBA? Real‑World Tests Reveal Its Strengths and Flaws

The article recounts a hands‑on exploration of ChatGPT’s abilities for database administration, highlighting impressive language understanding, notable mistakes such as confusing pg_resetwal with pg_resetxlog, and the broader implications of large language models for AI‑driven search and workflow automation.

AIChatGPTLLM
0 likes · 8 min read
Can ChatGPT Replace a DBA? Real‑World Tests Reveal Its Strengths and Flaws
ITPUB
ITPUB
Jan 31, 2023 · Databases

How Pigsty Turns PostgreSQL into a Cost‑Effective Open‑Source RDS Alternative

Pigsty is an open‑source platform that upgrades PostgreSQL across six dimensions—observability, reliability, availability, maintainability, extensibility, and interoperability—delivering enterprise‑grade features, built‑in monitoring, automatic failover, backup, and performance tuning while cutting cloud database costs dramatically.

High AvailabilityPostgreSQLRDS Alternative
0 likes · 22 min read
How Pigsty Turns PostgreSQL into a Cost‑Effective Open‑Source RDS Alternative
ITPUB
ITPUB
Dec 23, 2022 · Databases

Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation

This article explains the ACID properties of database transactions, clarifies the often‑confused concepts of consistency and isolation, details the four SQL standard isolation levels, compares lock‑based and MVCC concurrency controls, and examines concrete implementations in MySQL, PostgreSQL, and the distributed TDSQL system.

ACIDMVCCPostgreSQL
0 likes · 28 min read
Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation
21CTO
21CTO
Dec 20, 2022 · Databases

Explore PostgreSQL 15: New Features, Performance Boosts, and Upgrade Guide

PostgreSQL 15 introduces a safer permission model, up to four‑fold sorting speed improvements, a MERGE command, enhanced logical replication with two‑phase commit, parallel query execution, JSON logging, Zstandard/ZL4 compression, new regex functions, and shared‑memory server statistics, making it a compelling upgrade for developers and DBAs.

New FeaturesPostgreSQLVersion 15
0 likes · 6 min read
Explore PostgreSQL 15: New Features, Performance Boosts, and Upgrade Guide
Java Architecture Diary
Java Architecture Diary
Dec 19, 2022 · Backend Development

How to Add a Custom PostgreSQL Plugin to Nacos 2.2+ via SPI

Starting with Nacos 2.2.0, you can inject multiple data source plugins via the SPI mechanism; this guide walks through adding a PostgreSQL plugin, importing the required Maven dependencies, loading the database script, configuring connection details, and setting the datasource platform in application.properties.

NacosPostgreSQLSPI
0 likes · 3 min read
How to Add a Custom PostgreSQL Plugin to Nacos 2.2+ via SPI
ITPUB
ITPUB
Dec 7, 2022 · Databases

Can Modern OSes Replace Database Kernels? Insights on OS‑Database Synergy

The article examines whether today’s powerful operating systems can assume tasks traditionally handled by database kernels, tracing the evolution from early OS‑dependent databases to modern systems that leverage OS file cache, VMM, and storage optimizations, while also discussing scenarios where direct DB control remains necessary.

LinuxPostgreSQLStorage
0 likes · 8 min read
Can Modern OSes Replace Database Kernels? Insights on OS‑Database Synergy
Top Architect
Top Architect
Nov 3, 2022 · Backend Development

Improving Million-Row Insert Performance with Spring Boot ThreadPoolTaskExecutor

This article demonstrates how to boost the efficiency of inserting millions of records by configuring a ThreadPoolTaskExecutor in Spring Boot 2.1.1, using MyBatis‑Plus and PostgreSQL, providing code examples, performance test results, and best‑practice recommendations for multithreaded batch insertion.

BatchInsertMybatisPlusPostgreSQL
0 likes · 7 min read
Improving Million-Row Insert Performance with Spring Boot ThreadPoolTaskExecutor
dbaplus Community
dbaplus Community
Oct 15, 2022 · Databases

What’s New in PostgreSQL 15? Performance Boosts, New SQL Features, and Enhanced Replication

PostgreSQL 15, released on October 13 2022, brings major performance gains such as faster sorting and WAL compression, adds the SQL MERGE command, expands regex and multirange support, improves security with security_invoker, and enhances logical replication, logging, and configuration flexibility for modern data workloads.

LoggingPostgreSQLSQL features
0 likes · 6 min read
What’s New in PostgreSQL 15? Performance Boosts, New SQL Features, and Enhanced Replication
Hacker Afternoon Tea
Hacker Afternoon Tea
Oct 4, 2022 · Databases

Benchmarking Citus and PostgreSQL with HammerDB: Achieving 2 Million NOPM

This article explains how to automate and run HammerDB benchmarks for OLTP, OLAP, and HTAP workloads on Azure-hosted Citus‑extended PostgreSQL, discusses workload characteristics, benchmark specifications, challenges of HTAP testing, and shows how a 2 million new‑orders‑per‑minute result was achieved using open‑source tooling and configuration tips.

AzureCitusHTAP
0 likes · 19 min read
Benchmarking Citus and PostgreSQL with HammerDB: Achieving 2 Million NOPM
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2022 · Databases

SQLE 1.2208.0 Release Notes – New Features, MySQL Audit Rules, OceanBase Support, and Reporting Dashboard

The SQLE 1.2208.0 release introduces intelligent scanning for Alibaba Cloud RDS MySQL slow logs, adds numerous MySQL audit rules, opens enterprise‑level rules to the community, provides new OceanBase for MySQL audit rules, a reporting statistics page, PostgreSQL analysis support, and several scenario‑based audit enhancements along with many optimizations and bug fixes.

Database AuditingOceanBasePostgreSQL
0 likes · 9 min read
SQLE 1.2208.0 Release Notes – New Features, MySQL Audit Rules, OceanBase Support, and Reporting Dashboard
DataFunSummit
DataFunSummit
Aug 28, 2022 · Databases

Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance

This article presents an in‑depth overview of time‑series data concepts and the practical adoption of TimescaleDB built on PostgreSQL at Hytera, covering requirements, core features, hypertable architecture, deployment models, compression, data retention, backup strategies, and performance benchmarks.

CompressionPostgreSQLTime-series
0 likes · 14 min read
Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance
Programmer DD
Programmer DD
Aug 27, 2022 · Databases

Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading

When loading massive amounts of data into PostgreSQL, disabling autocommit, postponing index and foreign‑key creation, adjusting memory settings, using COPY or pg_bulkload, and fine‑tuning WAL and trigger settings can dramatically improve import speed and overall performance.

COPYPerformance TuningPostgreSQL
0 likes · 7 min read
Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading
Laravel Tech Community
Laravel Tech Community
Aug 16, 2022 · Databases

PostgreSQL Global Development Team Releases Updates for Supported Versions, Announces PostgreSQL 10 End‑of‑Life, Details CVE‑2022‑2625, and Introduces PostgreSQL 15 Beta 3

The PostgreSQL global development team announced updates for versions 14.5, 13.8, 12.12, 11.17, 10.22 and the third beta of PostgreSQL 15, highlighted the upcoming end‑of‑life for PostgreSQL 10, disclosed a security vulnerability (CVE‑2022‑2625) affecting versions 10‑14, and listed over 40 bug fixes and improvements.

CVE-2022-2625Database UpdatesPostgreSQL
0 likes · 6 min read
PostgreSQL Global Development Team Releases Updates for Supported Versions, Announces PostgreSQL 10 End‑of‑Life, Details CVE‑2022‑2625, and Introduces PostgreSQL 15 Beta 3
21CTO
21CTO
Aug 6, 2022 · Databases

August 2023 DB-Engines Ranking: Oracle Drops, MySQL & MongoDB Surge

The August 2023 DB‑Engines ranking shows Oracle’s steep 19.5‑point drop, while MySQL and MongoDB surge, PostgreSQL continues rising, and the top‑10 list highlights shifts across relational, key‑value, and document databases, with methodology based on search, job, and community metrics.

DB-EnginesOraclePostgreSQL
0 likes · 4 min read
August 2023 DB-Engines Ranking: Oracle Drops, MySQL & MongoDB Surge
Selected Java Interview Questions
Selected Java Interview Questions
Jul 10, 2022 · Databases

Comparison of PostgreSQL and MySQL

This article provides a detailed technical comparison between PostgreSQL and MySQL, covering architecture, stored procedures, transactions, performance, high availability, replication, permission control, SQL support, data types, fault tolerance, table organization, development interfaces, and community maintenance.

PostgreSQLSQLdatabase comparison
0 likes · 12 min read
Comparison of PostgreSQL and MySQL
Hacker Afternoon Tea
Hacker Afternoon Tea
Jun 20, 2022 · Databases

Citus 11 for PostgreSQL: Fully Open‑Source and Queryable from Any Node

Citus 11.0 makes the entire extension open source, adds a non‑blocking shard rebalancer, enables automatic schema and metadata synchronization so distributed queries can run on any cluster node, and introduces trigger support on distributed tables, with clear upgrade steps and deprecation notes.

CitusMetadata SyncPostgreSQL
0 likes · 15 min read
Citus 11 for PostgreSQL: Fully Open‑Source and Queryable from Any Node
Hacker Afternoon Tea
Hacker Afternoon Tea
May 27, 2022 · Databases

Exploring Citus 11.x Utility Functions for Distributed PostgreSQL

This article provides a comprehensive reference of Citus‑provided user‑defined functions—including table DDL, metadata management, cluster maintenance, and shard rebalancing utilities—detailing their purpose, required permissions, parameters, and behavior within a distributed PostgreSQL environment.

CitusDistributed TablesPostgreSQL
0 likes · 19 min read
Exploring Citus 11.x Utility Functions for Distributed PostgreSQL
Hacker Afternoon Tea
Hacker Afternoon Tea
May 23, 2022 · Databases

Citus 11.x Distributed PostgreSQL: Complete SQL Reference Guide

This reference outlines Citus 11.x distributed PostgreSQL SQL features, covering DDL operations, DML commands, rollup cache aggregation, distributed table queries, query processing, manual query propagation, and supported SQL workarounds, with links to detailed documentation.

CitusDDLDML
0 likes · 4 min read
Citus 11.x Distributed PostgreSQL: Complete SQL Reference Guide
Hacker Afternoon Tea
Hacker Afternoon Tea
May 12, 2022 · Backend Development

How to Enable Distributed Multi‑Tenant PostgreSQL (Citus) in a Python/Django App

This guide walks through migrating a single‑node Django multi‑tenant application to a distributed PostgreSQL backend using Citus, covering schema changes, primary‑key and unique‑constraint adjustments, integration of the django‑multitenant library, data distribution, range‑query updates, and middleware automation.

CitusDatabase MigrationDjango
0 likes · 14 min read
How to Enable Distributed Multi‑Tenant PostgreSQL (Citus) in a Python/Django App
Hacker Afternoon Tea
Hacker Afternoon Tea
May 2, 2022 · Databases

Running and Contributing to Citus 11 Documentation Locally

This guide explains how Citus shards data across machines to horizontally scale SQL queries for workloads over 100 GB, then walks through cloning the Citus 11 docs repository, setting up a pyenv‑based Python environment, installing Sphinx requirements, and launching the documentation in watch mode for local browsing.

CitusPostgreSQLSphinx
0 likes · 3 min read
Running and Contributing to Citus 11 Documentation Locally
IT Services Circle
IT Services Circle
Apr 21, 2022 · Operations

How to Install and Deploy Wiki.js Using Docker Compose

This article introduces the open‑source Wiki.js platform, explains its features, and provides a step‑by‑step guide to install it on Linux using Docker Compose, including Docker‑compose installation, configuration files, container management, and optional HTTPS setup with Caddy.

CaddyNode.jsPostgreSQL
0 likes · 7 min read
How to Install and Deploy Wiki.js Using Docker Compose
The Dominant Programmer
The Dominant Programmer
Apr 18, 2022 · Databases

How to Install PostgreSQL 14 on CentOS Using a Script

This guide walks through installing PostgreSQL 14 on a CentOS server via a shell script, covering repository setup, package installation, initialization, user and database creation, remote‑connection configuration, firewall adjustments, service verification, and connecting with Navicat.

CentOSPostgreSQLdatabase
0 likes · 4 min read
How to Install PostgreSQL 14 on CentOS Using a Script
Hacker Afternoon Tea
Hacker Afternoon Tea
Apr 17, 2022 · Databases

Introducing Stolon: Cloud‑Native High‑Availability for PostgreSQL

Stolon is an open‑source, cloud‑native manager that provides high‑availability for PostgreSQL by leveraging streaming replication, supporting any topology, integrating with Kubernetes, and using etcd, Consul, or the Kubernetes API for leader election and cluster storage.

Cloud NativeHigh AvailabilityKubernetes
0 likes · 3 min read
Introducing Stolon: Cloud‑Native High‑Availability for PostgreSQL
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 31, 2022 · Databases

Manual Query Propagation in Citus Distributed PostgreSQL Clusters

The article explains how Citus lets you manually propagate SQL statements to workers, shards, or placements using functions like run_command_on_workers, run_command_on_shards, and run_command_on_placements, provides concrete examples, and outlines important limitations and safety considerations.

CitusManual Query PropagationPostgreSQL
0 likes · 7 min read
Manual Query Propagation in Citus Distributed PostgreSQL Clusters
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 29, 2022 · Databases

Using Citus for Distributed PostgreSQL: SQL Reference for Querying Distributed Tables

This article explains how Citus extends PostgreSQL for distributed execution, detailing supported aggregation functions, count‑distinct handling, HyperLogLog columns, Top‑N estimation, percentile sketches with t‑digest, limit push‑down, view support, and various join strategies, while providing concrete SQL examples and configuration tips.

CitusHyperLogLogJoins
0 likes · 16 min read
Using Citus for Distributed PostgreSQL: SQL Reference for Querying Distributed Tables
ITPUB
ITPUB
Mar 24, 2022 · Databases

How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors

This article explains the cause of PostgreSQL "database is not accepting commands to avoid wraparound data loss" errors, details the XID allocation and wraparound mechanisms, and provides manual and automated vacuum‑freeze solutions with concrete SQL commands and scripts.

Database MaintenanceFreezePostgreSQL
0 likes · 14 min read
How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 24, 2022 · Databases

Quick Guide: Testing Citus Distributed PostgreSQL on Kubernetes with Distributed, Co‑located, Reference, and Columnar Tables

This tutorial walks through setting up a Citus‑enabled PostgreSQL cluster on Kubernetes, creating distributed tables, using co‑location and reference tables for high‑performance joins, and comparing row‑based versus columnar storage with concrete SQL commands and performance metrics.

CitusCo-locationDistributed Tables
0 likes · 11 min read
Quick Guide: Testing Citus Distributed PostgreSQL on Kubernetes with Distributed, Co‑located, Reference, and Columnar Tables
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 22, 2022 · Databases

Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)

This tutorial walks through setting up Citus, creating and distributing PostgreSQL tables for a multi‑tenant ad‑analytics application, loading sample data, executing CRUD and analytical queries, and extending the approach to real‑time GitHub event analysis, demonstrating end‑to‑end database operations in a distributed environment.

CitusPostgreSQLSQL
0 likes · 14 min read
Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 21, 2022 · Databases

Choosing the Right Distribution Column in Citus: Best Practices for Efficient Queries

This article explains how to select an optimal distribution column for Citus tables by first identifying whether your workload is multitenant SaaS or real‑time analytics, then applying concrete guidelines such as using high‑cardinality tenant or entity IDs, avoiding timestamps, ensuring uniform distribution, and leveraging co‑location for better query performance.

CitusPostgreSQLdata co-location
0 likes · 17 min read
Choosing the Right Distribution Column in Citus: Best Practices for Efficient Queries
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 20, 2022 · Databases

Official Guide to Installing a Distributed PostgreSQL (Citus) Cluster

This step‑by‑step guide shows how to set up both single‑node and multi‑node Citus clusters on Docker, Ubuntu/Debian, and Fedora/CentOS/Red Hat, covering repository addition, package installation, configuration of shared_preload_libraries, database initialization, worker node registration, and verification commands.

CentOSCitusPostgreSQL
0 likes · 14 min read
Official Guide to Installing a Distributed PostgreSQL (Citus) Cluster
ITPUB
ITPUB
Mar 18, 2022 · Databases

PostgreSQL vs MongoDB: How to Choose the Right Database for Your Project

The article reviews the 50‑year evolution of databases, explains why modern enterprises need multiple database types, compares PostgreSQL and MongoDB for a typical market‑place application, and highlights how team expertise and architectural constraints should drive the final selection.

MongoDBMulti-Model DatabasesPostgreSQL
0 likes · 9 min read
PostgreSQL vs MongoDB: How to Choose the Right Database for Your Project
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 18, 2022 · Backend Development

Building a Distributed Multi‑Tenant Database with Django, Postgres, and Citus

This guide demonstrates how to build a distributed multi‑tenant database using Django with Postgres and Citus, covering installation, supported Django versions, model modifications via mixins or inheritance, middleware for tenant context, automatic composite foreign keys, and the library’s API with concrete code examples.

CitusDjangoPostgreSQL
0 likes · 8 min read
Building a Distributed Multi‑Tenant Database with Django, Postgres, and Citus
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 17, 2022 · Databases

Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example

This guide shows how to combine PostgreSQL declarative time‑range partitioning with Citus distributed sharding to create a scalable time‑series database, covering table creation, distribution, automatic monthly partition generation, columnar archiving, maintenance with pg_cron, and performance benefits such as faster inserts, queries, and data expiration.

CitusPartitioningPostgreSQL
0 likes · 11 min read
Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 16, 2022 · Databases

Building a Real-Time Dashboard with Distributed PostgreSQL (Citus) – Official Example

This tutorial shows how to use Citus, a distributed PostgreSQL extension, to ingest immutable HTTP event logs, shard them by site_id, create real‑time and pre‑aggregated tables, schedule roll‑up jobs, handle data expiration, estimate distinct counts with HyperLogLog, and store unstructured JSONB counters for a low‑latency analytics dashboard.

CitusHyperLogLogJSONB
0 likes · 16 min read
Building a Real-Time Dashboard with Distributed PostgreSQL (Citus) – Official Example