Remove 2022 Remove Database Remove Monitoring Remove Storage
article thumbnail

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

2022 was an exciting year for Percona Monitoring and Management (PMM). These updates are designed to keep databases running at peak performance and simplify database operations. PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. We have tested PMM version 2.33.0

article thumbnail

PostgreSQL Vacuuming to Optimize Database Performance and Reclaim Space

Percona

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. PostgreSQL and other database management systems use MVCC to ensure consistent reads and prevent data loss from concurrent updates. It is essential to run a vacuum to keep the database running smoothly periodically.

Database 107
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Set up AI-powered observability for your Microsoft Azure cloud resources in just one click

Dynatrace

To establish the necessary monitoring, the observability team typically must be granted new setup permissions. For example, to monitor non-compute resources in Azure, many solutions require special components configured separately or even hosted by the customer. This process is often slow because component setup takes time.

Azure 222
article thumbnail

The Ultimate Guide to Database High Availability

Percona

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

article thumbnail

The Ultimate Guide to Open Source Databases

Percona

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

article thumbnail

Data lakehouse innovations advance the three pillars of observability for more collaborative analytics

Dynatrace

To solve this problem, Dynatrace launched Grail, its causational data lakehouse , in 2022. Grail combines the big-data storage of a data warehouse with the analytical flexibility of a data lake. This unified approach enables Grail to vault past the limitations of traditional databases.

Analytics 182
article thumbnail

PostgreSQL Partitioning Using Traditional Methods

Percona

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 84