Skip to content
Tagged articles

PostgreSQL

500 articles · Page 5 of 5
macrozheng
macrozheng
Mar 12, 2022 · Databases

March 2024 DB‑Engines Ranking: Who’s Rising and Who’s Falling?

The March 2024 DB‑Engines ranking reveals Oracle, MySQL and SQL Server losing ground while PostgreSQL surges, Snowflake climbs, and detailed top‑10 lists across relational, key‑value, document, time‑series, and graph databases illustrate shifting popularity trends based on five industry metrics.

DB-EnginesDatabase TrendsPostgreSQL
0 likes · 4 min read
March 2024 DB‑Engines Ranking: Who’s Rising and Who’s Falling?
ITPUB
ITPUB
Mar 10, 2022 · Databases

How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables

This article explains why querying the most recent record for a specific device in massive time‑series tables can be painfully slow in PostgreSQL, demonstrates the impact of using only a timestamp index, and presents several indexing and query‑design strategies—including composite indexes, lateral joins, SkipScan, recursive CTEs, and logging tables with triggers—to dramatically improve performance.

PostgreSQLSQLTime-Series
0 likes · 22 min read
How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables
ITPUB
ITPUB
Mar 8, 2022 · Databases

Mastering PostgreSQL Execution Plans: From Basics to Advanced Optimization

This article explains how PostgreSQL generates execution plans, details the plan tree structure, cost parameters, scan and join methods, and provides practical tips for using EXPLAIN, tuning planner settings, and applying hints to optimize SQL performance.

Join TypesPostgreSQLcost estimation
0 likes · 17 min read
Mastering PostgreSQL Execution Plans: From Basics to Advanced Optimization
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 6, 2022 · Databases

Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts

Citus extends PostgreSQL into a shared‑nothing distributed system where a coordinator node routes queries to worker nodes, supporting distributed, reference, and local tables, shard placement, replication modes, co‑location, parallel execution, and configurable connection‑pool settings to scale storage and CPU across a cluster.

CitusPostgreSQLdistributed database
0 likes · 12 min read
Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts
Hacker Afternoon Tea
Hacker Afternoon Tea
Feb 28, 2022 · Cloud Native

Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling

This guide explains how to combine a PostgreSQL Operator with Pgpool-II on Kubernetes to create a PostgreSQL cluster that supports query read‑load balancing and connection pooling, covering prerequisites, deployment steps, environment‑variable and ConfigMap configuration, backend settings, failover handling, password registration, streaming replication checks, SSL setup, and Prometheus monitoring.

Cloud NativeConfigMapKubernetes
0 likes · 13 min read
Running Pgpool-II on Kubernetes for PostgreSQL Query Load Balancing and Connection Pooling
Hacker Afternoon Tea
Hacker Afternoon Tea
Feb 25, 2022 · Databases

How Citus Turns PostgreSQL into a Distributed Database

Citus is an open‑source PostgreSQL extension that adds sharding, distributed tables and parallel query execution, enabling horizontal and vertical scaling for multi‑tenant SaaS, real‑time analytics, and massive workloads, while outlining acquisition options, practical use cases, and scenarios where it is unsuitable.

AzureCitusPostgreSQL
0 likes · 7 min read
How Citus Turns PostgreSQL into a Distributed Database
Hacker Afternoon Tea
Hacker Afternoon Tea
Feb 24, 2022 · Cloud Native

How to Create, Connect, and Delete a PostgreSQL Cluster with CrunchyData PGO (Cloud‑Native)

This tutorial walks through installing the CrunchyData Postgres Operator, creating a PostgreSQL cluster named hippo with kustomize, inspecting its resources, configuring services, secrets, and TLS for secure connections, modifying service types, deploying a Keycloak application using the generated credentials, and finally deleting the cluster while handling PVC retention.

Cloud NativeCrunchyDataKeycloak
0 likes · 12 min read
How to Create, Connect, and Delete a PostgreSQL Cluster with CrunchyData PGO (Cloud‑Native)
Ops Development Stories
Ops Development Stories
Feb 17, 2022 · Cloud Native

How to Build a Minimal‑Cost HA Harbor Registry with PostgreSQL Replication on Alibaba Cloud

This guide details a low‑overhead, highly available Harbor deployment on Alibaba Cloud, covering preparation of SLB, ECS, NFS storage, installation of Docker‑Compose, configuration of image mirrors, installation of Harbor 2.3, setup of PostgreSQL 13 master‑slave replication, Redis integration, backup procedures, failover handling, and disaster‑recovery strategies.

Alibaba CloudHarborHigh Availability
0 likes · 20 min read
How to Build a Minimal‑Cost HA Harbor Registry with PostgreSQL Replication on Alibaba Cloud
Qingyun Technology Community
Qingyun Technology Community
Jan 24, 2022 · Databases

Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices

This article explains why PostgreSQL data loss occurs, compares DDL and DML causes, and reviews several recovery tools—including pg_resetwal, pg_dirtyread, pg_recovery, pg_filedump, WalMiner, and pageinspect—providing usage examples, summaries, and practical recommendations for effective data restoration.

Database ToolsMVCCPostgreSQL
0 likes · 14 min read
Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices
Hacker Afternoon Tea
Hacker Afternoon Tea
Jan 16, 2022 · Databases

Sentry Developer Contribution Guide – Database Migrations

This guide explains how Sentry uses Django migrations to manage database schema changes, covering commands for upgrading, targeting specific migrations, generating SQL, creating and merging migrations, and detailed best‑practice procedures for handling filters, indexes, column and table modifications, foreign keys, and renaming while avoiding downtime.

Database MigrationsDjangoPostgreSQL
0 likes · 16 min read
Sentry Developer Contribution Guide – Database Migrations
Architects Research Society
Architects Research Society
Jan 7, 2022 · Databases

High‑Availability Clustering Solutions for PostgreSQL

This article explains the concepts of high availability, continuous recovery, and standby databases, then reviews various PostgreSQL clustering options such as DRBD, ClusterControl, Rubyrep, Pgpool‑II, Bucardo, Postgres‑XC, Citus, and PostgresXL, highlighting their features, advantages, and drawbacks.

ClusterControlDRBDDatabase Replication
0 likes · 16 min read
High‑Availability Clustering Solutions for PostgreSQL
JD Cloud Developers
JD Cloud Developers
Dec 24, 2021 · Databases

Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm

This article explains how PostgreSQL's native full‑text search, GIN indexes, and extensions like pg_trgm, pg_bigm, and pg_jieba can dramatically improve the speed and accuracy of Chinese address keyword searches, offering a cost‑effective alternative to external search engines.

GIN IndexPostgreSQLaddress keyword search
0 likes · 6 min read
Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm
Programmer DD
Programmer DD
Dec 16, 2021 · Databases

Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL

A former Oracle MySQL lead engineer explains why, after five years of work, he finds PostgreSQL a superior open‑source RDBMS, criticizing MySQL’s design flaws, comparing MariaDB, and highlighting real‑world migration experiences and industry perspectives.

Database MigrationMariaDBPostgreSQL
0 likes · 9 min read
Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL
21CTO
21CTO
Dec 14, 2021 · Databases

PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?

This article examines workload analysis and query performance differences between PostgreSQL and MySQL, focusing on JSON handling, indexing strategies, concurrency control, benchmark results, and replication features, while offering configuration tips to improve each database’s speed and efficiency.

Database PerformanceIndexingJSON
0 likes · 10 min read
PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?
Qingyun Technology Community
Qingyun Technology Community
Dec 7, 2021 · Databases

Master PostgreSQL Replication with repmgr: A Complete Guide

This article introduces repmgr, an open‑source PostgreSQL replication manager, covering its architecture, election mechanism, core tools, metadata tables, installation steps, command syntax, configuration options, and common operations for building high‑availability database clusters.

Database ClusteringHigh AvailabilityPostgreSQL
0 likes · 8 min read
Master PostgreSQL Replication with repmgr: A Complete Guide
Programmer DD
Programmer DD
Nov 27, 2021 · Databases

Deploy MangoDB: An Open‑Source MongoDB Alternative with Docker

This guide introduces MangoDB, an open‑source MongoDB‑compatible database built on PostgreSQL, and walks you through a three‑step Docker‑Compose setup, service startup, and connection using mongosh, enabling developers to quickly try a true open‑source MongoDB replacement.

MangoDBMongoDBPostgreSQL
0 likes · 4 min read
Deploy MangoDB: An Open‑Source MongoDB Alternative with Docker
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 12, 2021 · Databases

Implementing High‑Availability PostgreSQL with Keepalived: Architecture, Setup, and Failover Procedures

This article explains how to use Keepalived together with PostgreSQL to build a two‑node high‑availability cluster, covering Keepalived's VRRP mechanism, host planning, installation steps, asynchronous master‑slave replication configuration, monitoring scripts, and detailed failover drills.

Database ReplicationFailoverHigh Availability
0 likes · 20 min read
Implementing High‑Availability PostgreSQL with Keepalived: Architecture, Setup, and Failover Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 5, 2021 · Databases

SQLE 1.2111.0-pre1 Release Notes

The SQLE 1.2111.0-pre1 preview release introduces plugin-based support for arbitrary databases, provides a PostgreSQL plugin example, includes API adjustments, fixes a rule‑passing bug, and offers links to the source repository, documentation, and release information for users and administrators.

PostgreSQLSQLaudit
0 likes · 3 min read
SQLE 1.2111.0-pre1 Release Notes
ITPUB
ITPUB
Nov 2, 2021 · Databases

Why Open-Source Databases Like PostgreSQL Boost Security for Hybrid Workforces

Since the pandemic forced remote work, organizations must protect growing data across hybrid teams, and the article argues that open-source databases such as PostgreSQL offer stronger, more adaptable security than legacy closed-source systems by enabling rapid patching, community scrutiny, and cost-effective protection.

Database SecurityPostgreSQLdata protection
0 likes · 5 min read
Why Open-Source Databases Like PostgreSQL Boost Security for Hybrid Workforces
Ops Development Stories
Ops Development Stories
Sep 25, 2021 · Cloud Native

How to Deploy and Troubleshoot Kong & Konga on Kubernetes

This guide walks through deploying Kong and its UI Konga on Kubernetes, covering configuration of PostgreSQL, handling common initialization errors, correcting environment variables, and ensuring successful startup with detailed YAML and Docker commands.

KongKongaKubernetes
0 likes · 13 min read
How to Deploy and Troubleshoot Kong & Konga on Kubernetes
360 Tech Engineering
360 Tech Engineering
Sep 9, 2021 · Databases

PostgreSQL High‑Availability Cluster Deployment with Patroni and Etcd

This article details the design, deployment, configuration, operation, monitoring, and backup of a PostgreSQL high‑availability cluster built on Patroni, Etcd, and LVS at 360, covering hardware layout, software versions, installation steps, parameter tuning, fail‑over testing, and future outlook.

ClusterPatroniPostgreSQL
0 likes · 16 min read
PostgreSQL High‑Availability Cluster Deployment with Patroni and Etcd
Architects Research Society
Architects Research Society
Sep 4, 2021 · Databases

Why Data Scientists Should Learn PostgreSQL

This article explains why mastering SQL and PostgreSQL is essential for data scientists, outlines the core skills of the role, describes PostgreSQL’s features, lists its advantages and drawbacks for data science, and suggests resources for getting started.

HTAPPostgreSQLSQL
0 likes · 10 min read
Why Data Scientists Should Learn PostgreSQL
Programmer DD
Programmer DD
Aug 13, 2021 · Databases

August 2023 DB‑Engines Ranking: SQL Server’s Sharp Drop & PostgreSQL/MongoDB Surge

The August 2023 DB‑Engines popularity ranking shows Microsoft SQL Server suffering the steepest score decline, while PostgreSQL and MongoDB post significant year‑over‑year gains, and the top three databases also fell, with the report detailing score trends, category rankings, and the five metrics used to calculate popularity.

DB-EnginesDatabase RankingsMongoDB
0 likes · 4 min read
August 2023 DB‑Engines Ranking: SQL Server’s Sharp Drop & PostgreSQL/MongoDB Surge
Laravel Tech Community
Laravel Tech Community
Jun 15, 2021 · Databases

PostgreSQL JDBC Driver 42.2.21 Release Highlights

The PostgreSQL JDBC Driver (PgJDBC) version 42.2.21 introduces documentation updates for the deprecated DataSource API, ensures primary keys for updatable result sets, adds asynchronous notification handling, rewrites the OSGi bundle activator, and fixes metadata retrieval when search_path is not specified.

Database DriverJDBCJava
0 likes · 2 min read
PostgreSQL JDBC Driver 42.2.21 Release Highlights
IT Xianyu
IT Xianyu
Jun 15, 2021 · Databases

How to Size Database Connection Pools: Insights from HikariCP Performance Tests

The article explains how to determine the optimal size of a database connection pool by analyzing performance tests, presenting a simple formula based on CPU cores and disk count, and demonstrating that a much smaller pool can dramatically improve response times for high‑concurrency workloads.

HikariCPOptimizationPostgreSQL
0 likes · 11 min read
How to Size Database Connection Pools: Insights from HikariCP Performance Tests
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Understanding PostgreSQL Prepared Statements and Plan Caching (Generic vs Custom)

This article explains how PostgreSQL's prepared statements cache execution plans, describing the default behavior of generating custom plans for the first five executions before switching to a generic plan, and shows how PostgreSQL 14 adds generic_plans and custom_plans columns to the pg_prepared_statements view for monitoring.

Custom PlanDatabase PerformanceGeneric Plan
0 likes · 2 min read
Understanding PostgreSQL Prepared Statements and Plan Caching (Generic vs Custom)
macrozheng
macrozheng
May 17, 2021 · Databases

Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested

This article introduces the importance of database connections, compares three popular Java connection pools (DBCP, C3P0, Druid) with code examples, runs performance tests inserting 100 k and 1 M rows on MySQL, Oracle and PostgreSQL, and concludes with recommendations on the most stable pool and optimal databases.

Connection PoolDruidJava
0 likes · 11 min read
Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested
dbaplus Community
dbaplus Community
Mar 22, 2021 · Databases

Designing and Practicing Universal High‑Availability for MySQL and PostgreSQL

This article explains the principles, architecture models, and concrete implementations of high‑availability for MySQL and PostgreSQL, covering data‑sync modules, HA management, unified access, and cloud‑native considerations with detailed examples and best‑practice recommendations.

Database ClusteringHA managementHigh Availability
0 likes · 48 min read
Designing and Practicing Universal High‑Availability for MySQL and PostgreSQL
The Dominant Programmer
The Dominant Programmer
Mar 14, 2021 · Databases

How to Create a PostGIS Spatial Database and Import Shapefile Data

After installing PostgreSQL on Windows, this guide shows how to add the PostGIS extension via pgAdmin, create a new spatial database, verify the installation, and then use the PostGIS Shapefile and DBF Loader Exporter to import a shapefile (with accompanying DBF), handling encoding and path issues, and finally view the imported data.

GIS importPostGISPostgreSQL
0 likes · 4 min read
How to Create a PostGIS Spatial Database and Import Shapefile Data
ITPUB
ITPUB
Mar 6, 2021 · Databases

What Do the DB-Engines March 2021 Rankings Reveal About Today's Top Databases?

The DB‑Engines March 2021 ranking evaluates 364 databases, highlighting shifts among the top ten—including Microsoft SQL Server’s steep decline, MySQL’s growth surge, PostgreSQL’s continued rise, and Snowflake’s dramatic climb—while offering trend graphs and insights for professionals choosing the right database technology.

DB-EnginesPostgreSQLRanking
0 likes · 6 min read
What Do the DB-Engines March 2021 Rankings Reveal About Today's Top Databases?
Suning Technology
Suning Technology
Jan 19, 2021 · Databases

Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference

The 10th PostgreSQL China Technical Conference in January 2021 featured expert talks on scaling Citus clusters with logical replication and on applying PostgreSQL to Suning’s retail digitalization, highlighting architecture, challenges, technology choices, and future directions for database-driven business transformation.

CitusPostgreSQLdata architecture
0 likes · 2 min read
Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference
Tencent Cloud Developer
Tencent Cloud Developer
Jan 14, 2021 · Databases

PostgreSQL Master-Slave Replication Performance Optimization: Solving Drop Table Bottleneck

The article explains how massive DROP TABLE operations in PostgreSQL master‑slave replication trigger costly buffer‑invalidation loops that cause severe lag, and describes extracting this step into a separate subprocess with a shared hash table, cutting replication lag from over 400 GB to about 10 MB—a 30,000‑fold speedup.

Buffer ManagementDatabase InternalsDatabase Replication
0 likes · 7 min read
PostgreSQL Master-Slave Replication Performance Optimization: Solving Drop Table Bottleneck
21CTO
21CTO
Jan 6, 2021 · Databases

Why PostgreSQL, MariaDB, and Azure SQL Are Redefining the DB‑Engines Rankings

The latest DB‑Engines popularity ranking reveals Oracle, MySQL and SQL Server still dominate the top three, while PostgreSQL, MariaDB, Azure SQL Database and Snowflake surge ahead, highlighting a stable yet evolving landscape where cloud‑native databases are gaining rapid momentum.

Azure SQLDB-EnginesMariaDB
0 likes · 4 min read
Why PostgreSQL, MariaDB, and Azure SQL Are Redefining the DB‑Engines Rankings
dbaplus Community
dbaplus Community
Dec 10, 2020 · Databases

How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade

In May 2020 GitLab partnered with OnGres to upgrade a 12‑node PostgreSQL 9.6 cluster to version 11, using a carefully planned pg_upgrade process, automated Ansible playbooks, Patroni HA, and a detailed rollback strategy to keep a 6 TB dataset consistent while serving 300 k transactions per second.

AnsibleDatabase MigrationGitLab
0 likes · 16 min read
How GitLab Achieved a Near-Perfect PostgreSQL 9.6→11 Upgrade
Architects' Tech Alliance
Architects' Tech Alliance
Dec 4, 2020 · Databases

Comparison of MySQL and PostgreSQL: Features, Advantages, and Use Cases

This article provides a detailed comparison of MySQL and PostgreSQL, covering licensing, ACID compliance, SQL standard support, replication models, concurrency control, performance characteristics, high‑availability solutions, external data integration, storage engines, and overall strengths and weaknesses to help readers choose the most suitable open‑source database for their scenarios.

PostgreSQLdatabase comparisonmysql
0 likes · 12 min read
Comparison of MySQL and PostgreSQL: Features, Advantages, and Use Cases
dbaplus Community
dbaplus Community
Nov 22, 2020 · Databases

How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances

This article details Suning's journey of replacing commercial databases with PostgreSQL and Citus, covering background, feature and performance comparisons, reliability tests, deployment architecture, real‑world use cases, operational tips, and a comprehensive Q&A on migration and maintenance.

CitusDatabase MigrationOperational Experience
0 likes · 26 min read
How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances
Suning Technology
Suning Technology
Nov 22, 2020 · Databases

How Suning Scaled PostgreSQL to 4,000+ Instances for Smart Retail

Suning’s 2020 PostgreSQL case study, presented at PostgresConf.CN & PGConf.Asia, details how the company deployed over 4,000 instances, leveraged Citus, JSON, PostGIS and roaringbitmap, and achieved cost savings and smart‑retail capabilities across billing, analytics, location search and user profiling.

CitusPostgreSQLSmart Retail
0 likes · 3 min read
How Suning Scaled PostgreSQL to 4,000+ Instances for Smart Retail
Qunar Tech Salon
Qunar Tech Salon
Nov 5, 2020 · Databases

Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution

This article explains why a low‑traffic PostgreSQL 11 database can accumulate massive WAL files, analyzes relevant configuration parameters and replication slots, demonstrates diagnostic SQL commands, and provides step‑by‑step actions—including adjusting archive_timeout, handling replication slots, and forcing a checkpoint—to reclaim disk space.

Performance TuningPostgreSQLWAL
0 likes · 8 min read
Managing Excessive WAL Growth in PostgreSQL 11: Diagnosis and Resolution
Tencent Cloud Developer
Tencent Cloud Developer
Nov 2, 2020 · Databases

Overview of Tencent TBase: Distributed HTAP Database Architecture and Capabilities

Tencent’s TBase is an enterprise‑grade, PostgreSQL‑based distributed HTAP database that combines strong consistency, high‑concurrency OLTP and high‑performance OLAP within a single cluster, using a GTM‑coordinated two‑phase commit, flexible data distribution, parallel query optimization, and extensive security and scaling features.

HTAPPostgreSQLTBase
0 likes · 22 min read
Overview of Tencent TBase: Distributed HTAP Database Architecture and Capabilities
ITPUB
ITPUB
Oct 26, 2020 · Operations

Essential Unix Commands Every PostgreSQL DBA Should Know

This guide compiles the most useful Unix/Linux commands for PostgreSQL administrators, covering background execution, mail queue handling, email with attachments, file searching, cleanup, compression, diffing, remote synchronization, timestamp‑based file moves, and system reboot techniques.

DBALinuxPostgreSQL
0 likes · 11 min read
Essential Unix Commands Every PostgreSQL DBA Should Know
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 13, 2020 · Databases

Database Optimization Methodology and Parameter Tuning for Oracle, MySQL, PostgreSQL, and DM

This article presents a comprehensive methodology for database performance optimization, covering objectives, key metrics, common pitfalls, a step‑by‑step process, instance‑level best practices, and detailed parameter‑tuning tables for Oracle, MySQL (InnoDB), PostgreSQL, and DM databases.

DM DatabaseOracleParameter Optimization
0 likes · 10 min read
Database Optimization Methodology and Parameter Tuning for Oracle, MySQL, PostgreSQL, and DM
Suning Technology
Suning Technology
Sep 29, 2020 · Databases

How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail

Facing the post‑pandemic slowdown of e‑commerce growth, SuNing pioneered an O2O “smart retail” strategy by integrating online and offline channels through its “Anytime Business System,” which combines PostGIS‑enabled geospatial analysis, PostgreSQL high‑availability clustering with Citus, and seamless data flow across front‑end, transaction, and support layers.

CitusGeospatialO2O
0 likes · 17 min read
How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail
Architects Research Society
Architects Research Society
Sep 2, 2020 · Databases

Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication

This article explains how to extract maximum performance and scalability from PostgreSQL for multi‑terabyte workloads by leveraging specialized indexes, declarative partitioning, tablespaces, parallel query execution, read‑only replica load‑balancing, and foreign‑table sharding techniques.

ParallelismPartitioningPostgreSQL
0 likes · 10 min read
Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication
Architects Research Society
Architects Research Society
Aug 29, 2020 · Databases

Why Data Scientists Should Learn PostgreSQL

The article explains why SQL is essential for data scientists, introduces PostgreSQL as a powerful open‑source relational database suited for large‑scale data science, outlines its key features, advantages and disadvantages, and provides practical learning resources for beginners.

Learning ResourcesPostgreSQLSQL
0 likes · 9 min read
Why Data Scientists Should Learn PostgreSQL
Architects Research Society
Architects Research Society
Aug 16, 2020 · Databases

Insights into PostgreSQL: Community, Features, and Future Directions – Interview with Brad Nicholson and Dave Cramer

Brad Nicholson and Dave Cramer discuss their experiences with PostgreSQL, covering the project's community strengths and weaknesses, emerging pluggable storage, JSON path, Kubernetes deployment challenges, performance tuning, and their vision for the database’s evolution over the next decade.

KubernetesPluggable StoragePostgreSQL
0 likes · 20 min read
Insights into PostgreSQL: Community, Features, and Future Directions – Interview with Brad Nicholson and Dave Cramer
ITPUB
ITPUB
Aug 10, 2020 · Databases

Why Smaller Database Connection Pools Boost Performance: Real-World Test Insights

A detailed analysis shows that reducing the size of a database connection pool can dramatically lower request latency and improve throughput, with real benchmark data from Oracle and PostgreSQL illustrating how CPU, disk, and network constraints dictate the optimal pool size.

BenchmarkConnection PoolPostgreSQL
0 likes · 10 min read
Why Smaller Database Connection Pools Boost Performance: Real-World Test Insights
DevOps Coach
DevOps Coach
Aug 1, 2020 · Databases

Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know

This article presents a collection of practical PostgreSQL DBA techniques—including selective updates, bulk‑load optimizations, CTE‑based deduplication, partial and BRIN indexes, correlation tuning, and transactional DDL tricks—to help developers reduce database bottlenecks, improve query speed, and avoid common performance pitfalls.

BRINCTEDevOps
0 likes · 33 min read
Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know
IT Architects Alliance
IT Architects Alliance
Jul 27, 2020 · Industry Insights

Future of Databases: Oracle, DB2, SAP HANA, MySQL & NoSQL Trends

The article provides a comprehensive analysis of major relational databases—Oracle, DB2, SAP HANA, MySQL, PostgreSQL—and emerging NoSQL solutions, examining their underlying technologies, recent developments, market adoption, and the overall industry landscape shaping the future of data storage.

NoSQLOraclePostgreSQL
0 likes · 3 min read
Future of Databases: Oracle, DB2, SAP HANA, MySQL & NoSQL Trends
Senior Brother's Insights
Senior Brother's Insights
Jul 20, 2020 · Databases

Discover Why PostgreSQL Could Be the Underrated Database You Need

This article introduces PostgreSQL, the powerful open‑source object‑relational database, highlights its rising popularity in DB‑Engines rankings, compares its advanced features and performance advantages over MySQL, and outlines many of its unique capabilities such as rich data types, sophisticated indexing, and robust replication.

Feature comparisonIndexingPostgreSQL
0 likes · 6 min read
Discover Why PostgreSQL Could Be the Underrated Database You Need
MaGe Linux Operations
MaGe Linux Operations
Jul 11, 2020 · Databases

Unlocking Time‑Series Power: A Deep Dive into TimescaleDB

This article introduces TimescaleDB—a PostgreSQL extension for time‑series data—explaining its core concepts, data‑model choices, architecture, native compression, and provides step‑by‑step installation instructions on a CentOS 7 environment.

CompressionPostgreSQLTime Series
0 likes · 15 min read
Unlocking Time‑Series Power: A Deep Dive into TimescaleDB
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 3, 2020 · Databases

PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices

This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.

High AvailabilityOracle migrationPerformance Tuning
0 likes · 10 min read
PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices
Architects Research Society
Architects Research Society
Jun 9, 2020 · Databases

PostgreSQL vs SQL Server: Performance and Scalability Comparison

An in‑depth comparison of PostgreSQL and Microsoft SQL Server examines their concurrency, partitioning, indexing, compression, cross‑platform support, and overall performance and scalability, concluding that PostgreSQL generally outperforms SQL Server across these parameters while offering more cost‑effective and flexible features.

PostgreSQLSQL Serverdatabase comparison
0 likes · 6 min read
PostgreSQL vs SQL Server: Performance and Scalability Comparison
dbaplus Community
dbaplus Community
Jun 7, 2020 · Databases

MySQL vs PostgreSQL: Which Open‑Source Database Wins for Your Projects?

The article compares MySQL and PostgreSQL across open‑source licensing, ACID compliance, SQL standard support, replication methods, concurrency control, performance, high‑availability solutions, external data sources, and storage models, highlighting each system’s strengths and weaknesses to help readers choose the most suitable database.

PostgreSQLdatabase comparisonmysql
0 likes · 15 min read
MySQL vs PostgreSQL: Which Open‑Source Database Wins for Your Projects?
Qunar Tech Salon
Qunar Tech Salon
Mar 31, 2020 · Fundamentals

Ten Full‑Stack Engineering Lessons Learned from a Decade in Silicon Valley

The article shares ten practical lessons from a senior full‑stack engineer covering CSS specificity, component state design, backend code organization, PostgreSQL performance, the pitfalls of rushing releases, automation investment, mastering tools, MVP thinking, research‑driven development, and systematic scientific debugging.

Best PracticesCI/CDMVP
0 likes · 15 min read
Ten Full‑Stack Engineering Lessons Learned from a Decade in Silicon Valley
Tencent Cloud Developer
Tencent Cloud Developer
Mar 15, 2020 · Industry Insights

Who Rules the Database World? Insights from Tencent’s TVP Tech Forum

The article reviews a Tencent Cloud TVP closed‑door forum where experts compared MySQL 8.0, PostgreSQL, Redis and the cloud‑native CynosDB, highlighting each product’s technical strengths, ecosystem support, and the broader industry trend toward cloud‑native, multi‑database solutions as the future of data management.

Cloud NativeCynosDBPostgreSQL
0 likes · 17 min read
Who Rules the Database World? Insights from Tencent’s TVP Tech Forum
Architects Research Society
Architects Research Society
Jan 22, 2020 · Databases

How to Install PostgreSQL 12 on CentOS 7 and CentOS 8

This step‑by‑step guide explains how to add the PostgreSQL Yum repository, install PostgreSQL 12 client and server packages, initialize and start the database service, set the admin password, optionally enable remote access, and install the pgAdmin 4 web interface on CentOS 7 or 8 systems.

CentOSLinuxPostgreSQL
0 likes · 11 min read
How to Install PostgreSQL 12 on CentOS 7 and CentOS 8
Architects Research Society
Architects Research Society
Jan 20, 2020 · Databases

Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture

The article recounts Olery’s five‑year evolution from a Ruby‑centric stack using MongoDB and MySQL to a PostgreSQL‑based architecture, detailing schema‑less pitfalls, database requirements, migration strategies, code adaptations, and the measurable performance gains achieved after the transition.

Database MigrationMongoDBPostgreSQL
0 likes · 15 min read
Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture
ITPUB
ITPUB
Nov 4, 2019 · Databases

Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems

This article details more than fifty practical issues encountered when migrating financial applications from Oracle to PostgreSQL—including character sets, comment syntax, numeric precision, VARCHAR handling, sequence limits, type casting, operator overloading, and connectivity—while offering concrete solutions, code examples, and performance tips.

Database MigrationOraclePostgreSQL
0 likes · 16 min read
Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems