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 117

Database Open Source Traffic Small Business 117

Scalegrid

JUNE 9, 2020

June 9, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for their MySQL , PostgreSQL and Redis™ solutions on DigitalOcean. This launch is in addition to their current DigitalOcean offering for MongoDB® database , the only DBaaS to support this database on DigitalOcean.

Availability 227

Availability Open Source Benchmarking Database 227

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

Scalegrid

JULY 17, 2020

JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. In this post, we are going to show you tips and techniques on how to effectively store and index JSON data in PostgreSQL. Why Store JSON in PostgreSQL? Timeline of JSON Support in PostgreSQL.

Storage 321

Storage Database Efficiency Processing 321

Scalegrid

MARCH 30, 2021

March 30, 2021 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for Oracle Cloud Infrastructure (OCI) through their fully managed database hosting plans. PALO ALTO, Calif., Oracle […].

Database 243

Database Cloud Azure AWS 243

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 96

Availability Open Source Azure Hardware 96

Percona

DECEMBER 18, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Percona Distribution for PostgreSQL 14.10 Take a look.

Monitoring 88

Monitoring Open Source Servers Scalability 88

DZone

AUGUST 16, 2023

For example, in this use case scenario, the fintech service provider needs to connect the various transaction processing (TP) systems (MySQL, Oracle, and PostgreSQL) of its partnering banks. The ETL tool did not support join queries across different data sources, and it could not store data.

FinTech 130

FinTech Engineering Latency Data Engineering 130

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 76

Strategy Database Availability Monitoring 76

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What Exactly is Greenplum? At a glance – TLDR.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Percona

JUNE 9, 2023

Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters. In this short blog post, we will see how to quickly (and easily) monitor a PostgreSQL cluster managed by Patroni.

Monitoring 126

Monitoring Metrics Open Source Database 126

Percona

SEPTEMBER 4, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. Release highlights: Components now include pg_gather , the open source extension to assess the health of a PostgreSQL cluster by gathering performance and configuration data from PostgreSQL databases.

Open Source 79

Open Source Scalability Database Software 79

Percona

DECEMBER 4, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. 1 Percona Distribution for PostgreSQL 16.1 On November 29, 2023, we released Percona Distribution for PostgreSQL 16.1. 1 Percona Distribution for PostgreSQL 16.1 Take a look.

Open Source 81

Open Source Azure Servers Programming 81

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The ScaleGrid platform allows PostgreSQL users to automate their daily operations without having to sacrifice control over their deployments. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Scalegrid

APRIL 16, 2020

But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Here are the databases and cloud providers supported through each model: Supported Databases. PostgreSQL.

Cloud 242

Cloud Azure AWS Database 242

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 116

Cache Open Source Benchmarking Database 116

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 79

Open Source Healthcare Social Media Database 79

Percona

NOVEMBER 13, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. Updated Release of Percona Distribution for PostgreSQL 16.0 The updated release of Percona Distribution for PostgreSQL 16.0 Updated Release of Percona Distribution for PostgreSQL 16.0

Innovation 88

Innovation Open Source Scalability Database 88

Dynatrace

MAY 13, 2021

Establishing end-to-end observability insights for today’s highly dynamic and exceedingly complex cloud-native production environments represents an enormous challenge to IT operations and SRE teams who are responsible for ensuring that hundreds, or even thousands, of running services meet with agreed upon SLOs.

Java 161

Java Analytics Metrics Database 161

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 86

Open Source Database Availability Design 86

Percona

OCTOBER 19, 2023

We highly appreciate all your effort and support. We highly appreciate all your effort and support. Vitaliy Orbidan added the ability to add external replicaset members when the replicaset is not exposed via k8s service to Percona Operator for MongoDB. Percona stands for open source and keeps open source open for everyone.

Open Source 104

Open Source Traffic Virtualization Metrics 104

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 121

Cloud Serverless AWS Storage 121

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

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

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 85

Open Source Storage Database C++ 85

Percona

JULY 7, 2023

Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL provides the foundation to start high availability, including features and configurations for physical and logical replication and consistent physical backups with point-in-time recovery (PITR) capabilities. This ensures continuous business operations.

Availability 85

Availability Open Source Architecture Database 85

Percona

APRIL 20, 2023

PostgreSQL does not natively support Transparent Data Encryption (TDE). As for FDE, there are multiple options available for PostgreSQL. For example, in Google Kubernetes Engine (GKE), you need to create the key in Cloud Key Management Service (KMS) and set it in the StorageClass: apiVersion: storage.k8s.io/v1beta1

Storage 121

Storage AWS Cloud Database 121

Scalegrid

OCTOBER 7, 2019

PostgreSQL popularity is skyrocketing in the enterprise space. We recently attended the PostgresConf event in San Jose to hear from the most active PostgreSQL user base on their database management strategies. Most Popular Cloud Providers for PostgreSQL Hosting. of PostgreSQL cloud use compared to 55.0%

Strategy 182

Strategy Cloud Java Open Source 182

Percona

JUNE 12, 2023

With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. A business can also incur reputational damage and face penalties for not meeting Service Level Agreements (SLAs). This blog provides links to such architectures — for MySQL and PostgreSQL software.

Architecture 98

Architecture Availability Open Source Healthcare 98

Percona

JULY 10, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. Percona Distribution for PostgreSQL 15.3

Monitoring 78

Monitoring Open Source Scalability Database 78

Percona

OCTOBER 2, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. 26 Percona Distribution for PostgreSQL 16.0 Percona Distribution for PostgreSQL 16.0 This release of Percona Distribution for PostgreSQL is based on PostgreSQL 16.

Open Source 82

Open Source Scalability Database Servers 82

Percona

AUGUST 30, 2023

PostgreSQL allows its users to set parameters at different scopes, and the same parameter can be specified at different places and using different methods. This acts as the default value for PostgreSQL. If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code.

Database 104

Database Servers Open Source Tuning 104

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. One is Main, and the other is Disaster Recovery (DR).

Storage 122

Storage Cloud Network Traffic 122

Scalegrid

DECEMBER 6, 2023

Database as a Service (DBaaS) and managed databases offer distinct advantages along with certain challenges. Understanding these pros and cons can help one make an informed decision about which database service works best for them. DBaaS provides streamlined management with maintenance-free operations & enhanced security.

Database 130

Database Cloud Hardware Storage 130

Percona

MAY 8, 2023

It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. Take a look! Percona Monitoring and Management 2.37

Monitoring 79

Monitoring Open Source Database Servers 79

Percona

JANUARY 30, 2023

PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. Instead, it seems PostgreSQL Developers are of the opinion that encryption is a storage-level problem and is better solved on the filesystem or block device level. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 126

Database Storage Government Open Source 126

Percona

MARCH 13, 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. Join us at this event if you are interested!

Serverless 119

Serverless C++ Storage Latency 119