Percona

MARCH 22, 2024

PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up.

Database 111

Database 111

Scalegrid

APRIL 8, 2022

PostgreSQL replication comes in two forms, and both have their niche uses. Replicating the information stored on your database is essential for distributing data and ensuring you have a backup that can be used for disaster recovery, in case something goes wrong.

Database 239

Database 239

Scalegrid

MARCH 10, 2022

PostgreSQL Features and Use Cases PostgreSQL is an open-source Object-relational Database Management System (DBMS). It’s an advanced database management and analysis system that’s mainly used for eCommerce platforms, payment transactions, and various data warehousing solutions.

Ecommerce 246

Ecommerce Open Source Database Systems 246

Percona

APRIL 9, 2024

For PostgreSQL users, the tech preview release availability of the new encryption extension pg_tde delivers unmatched protection for vital data assets.What is pg_tde?pg_tde, pg_tde, developed by Percona, is an open source […]

Open Source 111

Open Source Database Availability Development 111

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. For example, suppose you are tasked to migrate a well-performing, albeit aging, DBMS to a cutting-edge PostgreSQL one; how would you do it? PostgreSQL version 16.0 MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 123

Open Source Database Architecture Design 123

Scalegrid

SEPTEMBER 12, 2021

PostgreSQL also introduced many other breakthrough features in versions 10 through 11, 12 and 13 that make it a real competitor against Oracle, such as partitioning enhancements, parallel query and logical replication. New […].

240

240

Percona

JUNE 14, 2023

A few days ago, Heikki Linnakangas posted a message in the PostgreSQL mailing list titled “Let’s make PostgreSQL multi-threaded.” Should PostgreSQL become multi-threaded ? PostgreSQL has great performance despite this, yes, but it is surely an opportunity to improve performance, especially for some workloads.

Architecture 131

Architecture Operating System Database Processing 131

Percona

MARCH 21, 2024

PostgreSQL has a feature called data checksum which is used to detect any storage-level corruption of data pages. However, a new PostgreSQL database cluster does not have this feature enabled by default. what about […]

Storage 86

Storage Database 86

Percona

JANUARY 30, 2024

Are you planning to upgrade your PostgreSQL database but feeling overwhelmed by the complexity of the task? Introducing The Ultimate PostgreSQL Upgrade Checklist – designed to guide both seasoned and new DBAs and developers through the intricate process of a PostgreSQL upgrade.Why you need this […]

Database 93

Database Design Processing Development 93

Percona

DECEMBER 11, 2023

Deploying PostgreSQL on Kubernetes is not new and can be easily streamlined through various Operators, including Percona’s. To instruct Percona Operator for PostgreSQL which storage class to use, set it the spec. PostgreSQL cluster provides the best availability, but also comes with high compute costs. instances. [ ].

Storage 106

Storage Strategy Cloud Azure 106

Scalegrid

DECEMBER 19, 2019

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Database Architecture Servers 246

Percona

MARCH 12, 2024

PostgreSQL extensions are great! Simply by adding an extension, one transforms what is an otherwise vanilla general-purpose database management system into one capable of processing data requirements in a highly optimized fashion. ’d like […]

Database 111

Database Systems Processing Development 111

Percona

JULY 6, 2023

Locking in PostgreSQL is a mechanism used to control concurrent access to shared resources, ensuring data consistency and preventing conflicting operations. PostgreSQL offers various lock types, each serving a specific purpose. Let’s explore how locking works in PostgreSQL.

Open Source 119

Open Source Database Design Efficiency 119

Scalegrid

MARCH 23, 2020

Pgpool-II is the swiss army knife of PostgreSQL middleware. While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. The architecture is similar to PostgreSQL server: one process = one connection.

Cache 264

Cache Servers Architecture Processing 264

DZone

FEBRUARY 27, 2023

You’ll find basic and advanced optimization techniques using Django and PostgreSQL, yet most of the principles we discuss are general enough to be applied to other frameworks or relational databases. This article showcases optimization techniques that had great results at GitGuardian.

Database 226

Database Testing 226

Percona

JUNE 9, 2023

In this short blog post, we will see how to quickly (and easily) monitor a PostgreSQL cluster managed by Patroni. I will assume you already have an environment set up and running in which the PMM client is already monitoring the PostgreSQL database. PostgreSQL information like version, if it’s running, its timeline number, etc.

Monitoring 126

Monitoring Metrics Open Source Database 126

Percona

APRIL 26, 2024

The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared to our previous MVP release. In addition to lots of bug fixes, the new release supports multi-tenancy and key rotation with a simplified configuration mechanism.

Software 56

Software Software 56

Scalegrid

AUGUST 22, 2019

In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover. Patroni for PostgreSQL. How it Works. Patroni needs python 2.7

Availability 277

Availability Servers Network Open Source 277

Percona

APRIL 17, 2024

This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context” We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch between these setups to test them effectively.In

AWS 91

AWS Google Cloud Testing 91

Percona

DECEMBER 26, 2023

This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard. pg_stat_monitor About pg_stat_monitor is a Query Performance Monitoring tool for PostgreSQL. And yes, it even works in PostgreSQL.

Benchmarking 123

Benchmarking Metrics C++ Database 123

Percona

JUNE 23, 2023

For more than a quarter of a century, people have been discussing “Which is better, MySQL or PostgreSQL?” Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. ” — with no resolution.

Database 121

Database Transportation Servers Cloud 121

Scalegrid

JULY 13, 2020

One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. In this article, we compare Oracle vs. PostgreSQL, outlining the differences in these SQL database costs, features, and ease of use for both developers and database administrators (DBA’s) alike. PostgreSQL Community.

Open Source 244

Open Source Tuning C++ Database 244

Scalegrid

JULY 29, 2020

In our previous posts in this series, we spoke at length about using PgBouncer and Pgpool-II , the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment. PostgreSQL Connection Pooling Series. PostgreSQL high availability is supported through Pgpool-II in-built watcher processes.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Percona

MARCH 28, 2024

Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. Progress is ongoing, and Percona would love your feedback, so please download and test.DocumentationThe pg_tde documentation is here.

Database 80

Database Open Source Software Software 80

Percona

MARCH 4, 2024

Percona Operator for PostgreSQL is now Red Hat OpenShift certified. You can now use Percona Operator for PostgreSQL to deploy and manage highly available PostgreSQL clusters on OpenShift. It is fully supported by Red Hat’s […]

Availability 87

Availability Cloud Software Software 87

Scalegrid

JUNE 4, 2020

ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database. They support PostgreSQL, MySQL and Redis, but for the sake of this article, we are going to focus on their PostgreSQL product. ScaleGrid PostgreSQL provides on average 42.3%

Database 230

Database Latency Benchmarking Performance 230

Percona

MARCH 20, 2024

In a previous blog, One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only, we reviewed three ways PostgreSQL can use an index to retrieve data as quickly as possible. In the same blog, we saw the fastest and most efficient method is the Index-Only Scan because this saves time by avoiding the […]

Efficiency 97

Efficiency 97

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. In this post, we discuss the top 5 GUI tools for administering your PostgreSQL deployments. The window-based interface makes it much easier to manage your PostgreSQL data.

Open Source 262

Open Source Database Azure Cloud 262

Percona

SEPTEMBER 19, 2023

PostgreSQL Community released PostgreSQL 16 on September 14, 2023. In years past, we’ve released our Distribution for PostgreSQL a few months later. It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! PostgreSQL 16 comes packed with features.

Availability 111

Availability Open Source Database Servers 111

Percona

APRIL 3, 2024

A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database.PostgreSQL implements portions of the SQL/MED specification, allowing access to data that resides outside PostgreSQL using regular SQL queries.

Database 82

Database Systems 82

Percona

AUGUST 29, 2023

PostgreSQL has become increasingly popular in modern cloud-native environments. However, managing PostgreSQL clusters on Kubernetes can be a complex task. This is where the Percona Operator comes into play, offering a powerful solution to deploy and manage PostgreSQL clusters effortlessly. Search for init SQL. Interested?

Storage 97

Storage Database Media Open Source 97

Percona

DECEMBER 20, 2023

Huge pages make PostgreSQL faster; can we implement it in Kubernetes? Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. During the deployment procedure on the custom resource apply stage , Percona Operator for PostgreSQL 2.2.0

C++ 100

C++ Virtualization Benchmarking Database 100

Percona

JANUARY 30, 2024

PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that I reviewed last October. In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to […] There have been a lot of changes that covered in this post.

Software 109

Software Software Development Open Source 109

Percona

MAY 29, 2023

With multi-cloud or multi-regional PostgreSQL deployments, the complexity of managing disaster recovery only amplifies. This is where the Percona Operators come in, providing a solution to streamline disaster recovery for PostgreSQL clusters running on Kubernetes. Try Percona Operator for PostgreSQL today!

Storage 122

Storage Cloud Network Traffic 122

Percona

APRIL 2, 2024

One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. Years later, that same sentiment is still […]

Availability 83

Availability 83

Percona

OCTOBER 19, 2023

Welcome to the first installment of our series: Scalable Solutions with Percona Distribution for PostgreSQL. In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. and Percona Distribution for PostgreSQL 15. This tutorial will use Ubuntu 20.04

Scalability 87

Scalability Database Open Source Traffic 87

Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 125

Database Servers Testing Programming 125