Software - Technology Performance Pulse

Dynatrace announces support of Google Cloud’s AlloyDB for PostgreSQL metrics ingest

Dynatrace

MARCH 29, 2023

Today, Dynatrace is announcing that it has successfully achieved Google Cloud Ready – AlloyDB designation in support of an extended integration to Google Cloud’s AlloyDB for PostgreSQL. AlloyDB is a fully managed, PostgreSQL-compatible database service for highly demanding enterprise database workloads.

Google

Google Metrics Cloud Analytics

Should PostgreSQL Become Multi-Threaded?

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

Architecture Operating System Database Processing

MySQL or PostgreSQL: Which is Better?

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

Database Transportation Servers Cloud

PG_TDE Update: Percona’s Project to Add Transparent Data Encryption to PostgreSQL

Percona

JANUARY 30, 2024

PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond that I reviewed last October. This software is under active development. In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to […]

Software

Software Software Development Open Source

Protect Your PostgreSQL Database with pg_tde: Safe and Secure

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

Open Source Database Availability Development

Migrating from MySQL to PostgreSQL Using pgloader

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

Open Source Database Architecture Design

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

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

Open Source Tuning C++ Database

Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test

Percona

OCTOBER 16, 2023

PG_TDE is an experimental transparent data encryption access method for PostgreSQL 16 and beyond. This software is under active development and at a very early stage of design and implementation. Since PostgreSQL doesn’t have TDE features yet, Percona wants to provide the TDE feature as an extension to PostgreSQL.

Open Source

Open Source Testing Database Design

Storage Strategies for PostgreSQL on Kubernetes

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

Storage Strategy Cloud Azure

Managing High Availability in PostgreSQL – Part III: Patroni

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

Availability Servers Network Open Source

Trying out the PostgreSQL pg_tde Tech Preview Release

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

Software Software

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

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

Benchmarking Metrics C++ Database

Multi-tenants and Branches in Neon Serverless PostgreSQL

Percona

MARCH 21, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Introduction Recently, Percona introduced Percona Builds for Neon ( Introducing Percona Builds for Serverless PostgreSQL ), which makes it easy to install and experiment with serverless PostgreSQL. Interested in serverless PostgreSQL?

Serverless

Serverless Software Architecture Virtualization Database

What Is PostgreSQL Used For?

Percona

AUGUST 17, 2023

In building-block order, here are all three questions, followed by short answers (but please don’t go anywhere; we’ll expand on the answers and build to an enterprise-grade payoff): What is PostgreSQL? PostgreSQL is open source relational database management software. What is PostgreSQL used for?

Open Source

Open Source Healthcare Social Media Database

Percona’s PostgreSQL pg_tde Extension: March Update

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

Database Open Source Software Software

Percona Operator for PostgreSQL is Red Hat OpenShift Certified

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

Availability Cloud Software Software

Percona Distribution for PostgreSQL 16 Is Now Available

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

Availability Open Source Database Servers

Bootstrap PostgreSQL on Kubernetes

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

Storage Database Media Open Source

Using Huge Pages with PostgreSQL Running Inside Kubernetes

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++

C++ Virtualization Benchmarking Database

PostgreSQL 11 Will Soon Reach End of Life

Percona

NOVEMBER 8, 2023

According to the official PostgreSQL versioning policy page , the final PostgreSQL 11 release is expected by November 9, 2023. Since no new releases are planned by that date, PostgreSQL 11 has effectively reached its End of Life. Before updating, consider reviewing our post on updating legacy PostgreSQL.

Strategy

Strategy Database Availability Monitoring

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

Percona

DECEMBER 19, 2023

PG_TDE (PostgreSQL Transparent Data Encryption) is an experimental transparent data encryption access method for PostgreSQL 16, available on GitHub as an extension for vanilla PostgreSQL. Today, we’d like to share more details about the extension, including information about its internal architecture.

Open Source

Open Source Storage Database C++

Disaster Recovery for PostgreSQL on Kubernetes

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

Storage Cloud Network Traffic

Scalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances

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

Scalability Database Open Source Traffic

How to Install and Run PostgreSQL Using Docker

Percona

NOVEMBER 2, 2023

Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker. ” We intend to show how to bring up PostgreSQL instance(s) into Docker containers. .”

Database

Database Open Source Scalability Virtualization

Setting Up and Deploying PostgreSQL for High Availability

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. But PostgreSQL does not offer a complete HA solution. The same changes made in the primary database are made in the replicas.

Availability

Availability Open Source Architecture Database

Ready-to-Use High Availability Architectures for MySQL and PostgreSQL

Percona

JUNE 12, 2023

Open source databases provide great foundations for high availability — without the pitfalls of vendor lock-in that can come with proprietary software. However, open source software doesn’t typically include built-in HA solutions. This blog provides links to such architectures — for MySQL and PostgreSQL software.

Architecture

Architecture Availability Open Source Healthcare

Reducing PostgreSQL Costs in the Cloud

Percona

FEBRUARY 24, 2023

If you’re using PostgreSQL in the cloud, there’s a good chance you’re spending more than you need in order to get the results you need for your business. Usage reduction: What to look for to reduce PostgreSQL cloud costs The first step in cost reduction is to use what you need and not more. Don’t pay for capacity you don’t use or need.

Cloud

Cloud Serverless AWS Storage

PostgreSQL: Pgpool-II Use Cases and Benefits

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability, scalability, and performance. In this blog post, we will explore the benefits of using pgpool-II for PostgreSQL.

Cache

Cache Open Source Benchmarking Database

PostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary

Percona

MARCH 20, 2024

When checking for how good (or bad) a PostgreSQL instance is behaving, one just wants to see everything that matters on a single-ish page. That’s what the new summary dashboard in Percona Monitoring and Management (PMM) is achieving: So, what is “everything that matters”?

Monitoring

Monitoring Database Software Software

Easy Way to Provision a PostgreSQL Cluster on Kubernetes

Percona

MARCH 6, 2024

If you are reading this blog post, chances are you’re either curious about Kubernetes Operators, or you’ve specifically decided to install the Percona Operator for PostgreSQL, which I am glad to know!Suppose Suppose your environment isn’t set up yet.

Cloud

Cloud Software Software

Deploy Django on Kubernetes With Percona Operator for PostgreSQL

Percona

JUNE 20, 2023

Developers need an efficient, reliable way to run their Django applications with a robust PostgreSQL. Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. Django uses it to connect to the database.

Database

Database Open Source Engineering Efficiency

Percona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023

Percona

DECEMBER 18, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. Percona Distribution for PostgreSQL 14.10 Take a look.

Monitoring

Monitoring Open Source Servers Scalability

Percona PG_TDE and Docker: Please Test Transparent Data Encryption for PostgreSQL

Percona

JANUARY 26, 2024

Unlike some other databases, PostgreSQL does not have a native solution to encrypt data on disk transparently. Securing your data can be a tough task. Percona is developing PG_TDE to encrypt that data using the AES-CTR encryption algorithm.

Testing

Testing Database Code Development

Announcing the General Availability of Percona Operator for PostgreSQL Version 2

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. The solution is 100% open source and automates the deployment and management of PostgreSQL clusters on Kubernetes. What is better in version 2 compared to version 1?

Availability

Availability Open Source Azure Hardware

Percona Distribution for PostgreSQL 16.1, Percona Distribution for MySQL 8.1.0: Release Roundup December 4, 2023

Percona

DECEMBER 4, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. 1 Percona Distribution for PostgreSQL 16.1 Take a look.

Open Source

Open Source Azure Servers Programming

End of Life Notification for PostgreSQL 10

Percona

FEBRUARY 14, 2023

The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page. Please remember that the final PostgreSQL 11 release is planned for November 9, 2023. Following Percona’s Release Lifecycle policies, we follow and recommend PostgreSQL community timelines.

Open Source

Open Source Database Availability Design

Using Encryption-at-Rest for PostgreSQL in Kubernetes

Percona

APRIL 20, 2023

PostgreSQL does not natively support Transparent Data Encryption (TDE). As for FDE, there are multiple options available for PostgreSQL. I will use Percona Operator for PostgreSQL v2 (currently in tech preview) in my tests, but such an approach can be used with any Percona Operator. apiVersion: storage.k8s.io/v1

Storage

Storage AWS Cloud Database

Why PostgreSQL Is a Top Choice for Enterprise-level Databases

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database

Database Open Source Traffic Small Business

WAL Compression in PostgreSQL and Recent Improvements in Version 15

Percona

JANUARY 24, 2023

Attempts to compress PostgreSQL WAL at different levels have always been around since the beginning. But it is time to take another look at the built-in wal_compression because PostgreSQL 15 has much more to offer. Let’s look at what PostgreSQL offers internally for WAL compression.

Database

Database Benchmarking Open Source Latency

Scalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus

Percona

OCTOBER 20, 2023

This blog post is part two of a multi-post series about using the Citus extension with Percona Distribution for PostgreSQL. You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. Citus maintains seamless integration with PostgreSQL.

Scalability

Scalability Database Open Source Operating System

Google Cloud Next 2024: AI innovation for Google Cloud

Dynatrace

MARCH 29, 2024

With Dynatrace Davis® , Vertex AI, and Gemini for Google Cloud, this strategic partnership aims to meet developers’ needs, facilitating rapid application development, expediting time to value, and eliminating friction across the software development and delivery continuum.

Google

Google Innovation Cloud Analytics

Making it Easier to Manage a Production PostgreSQL Database

Scalegrid

NOVEMBER 12, 2019

The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. In this aspect, PostgreSQL does not hold up very well. In this blog post, we will detail some of these operational challenges with PostgreSQL. This mechanism is not built into PostgreSQL.

Database

Database Open Source Storage Servers

Innovation Release of Percona XtraDB Cluster, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023

Percona

NOVEMBER 13, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. Updated Release of Percona Distribution for PostgreSQL 16.0

Innovation

Innovation Open Source Scalability Database

Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

Percona

OCTOBER 2, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. 26 Percona Distribution for PostgreSQL 16.0 Take a look.

Open Source

Open Source Scalability Database Servers

Dynatrace announces support of Google Cloud’s AlloyDB for PostgreSQL metrics ingest

Should PostgreSQL Become Multi-Threaded?

Trending Sources

MySQL or PostgreSQL: Which is Better?

PG_TDE Update: Percona’s Project to Add Transparent Data Encryption to PostgreSQL

Protect Your PostgreSQL Database with pg_tde: Safe and Secure

Migrating from MySQL to PostgreSQL Using pgloader

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test

Storage Strategies for PostgreSQL on Kubernetes

Managing High Availability in PostgreSQL – Part III: Patroni

Trying out the PostgreSQL pg_tde Tech Preview Release

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

Multi-tenants and Branches in Neon Serverless PostgreSQL

What Is PostgreSQL Used For?

Percona’s PostgreSQL pg_tde Extension: March Update

Percona Operator for PostgreSQL is Red Hat OpenShift Certified

Percona Distribution for PostgreSQL 16 Is Now Available

Bootstrap PostgreSQL on Kubernetes

Using Huge Pages with PostgreSQL Running Inside Kubernetes

PostgreSQL 11 Will Soon Reach End of Life

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

Disaster Recovery for PostgreSQL on Kubernetes

Scalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances

How to Install and Run PostgreSQL Using Docker

Setting Up and Deploying PostgreSQL for High Availability

Ready-to-Use High Availability Architectures for MySQL and PostgreSQL

Reducing PostgreSQL Costs in the Cloud

PostgreSQL: Pgpool-II Use Cases and Benefits

PostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary

Easy Way to Provision a PostgreSQL Cluster on Kubernetes

Deploy Django on Kubernetes With Percona Operator for PostgreSQL

Percona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023

Percona PG_TDE and Docker: Please Test Transparent Data Encryption for PostgreSQL

Announcing the General Availability of Percona Operator for PostgreSQL Version 2

Percona Distribution for PostgreSQL 16.1, Percona Distribution for MySQL 8.1.0: Release Roundup December 4, 2023

End of Life Notification for PostgreSQL 10

Using Encryption-at-Rest for PostgreSQL in Kubernetes

Why PostgreSQL Is a Top Choice for Enterprise-level Databases

WAL Compression in PostgreSQL and Recent Improvements in Version 15

Scalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus

Google Cloud Next 2024: AI innovation for Google Cloud

Making it Easier to Manage a Production PostgreSQL Database

Innovation Release of Percona XtraDB Cluster, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023

Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

Stay Connected