Adam Furmanek

CORE

DevRel at Metis

Joined Sep 2023

https://www.metisdata.io/

Stats

Reputation:	1116
Pageviews:	60.9K
Articles:	17
Comments:	2

Articles
Comments

Articles

How and Why the Developer-First Approach Is Changing the Observability Landscape

Developers play a crucial role in modern companies. Explore more about the need to have a developer-first approach and include observability from day one.

December 11, 2024

· 1,450 Views · 1 Like

Everyone Uses Postgres...But Why?

All big players in the market use PostgreSQL nowadays. But why is that? Find out the answer in this article.

November 20, 2024

· 5,905 Views · 12 Likes

VACUUM In Postgres Demystified

Let’s learn about VACUUM in PostgreSQL: what it is, how it relates to MVCC, how it’s useful, and how to improve your database performance.

October 15, 2024

· 3,185 Views · 7 Likes

PostgreSQL Everywhere and for Everything

PostgreSQL is versatile and can successfully handle less popular SQL scenarios and workflows that don’t use SQL at all. Let's see where Postgres shines.

October 8, 2024

· 7,185 Views · 9 Likes

Why Doesn't Postgres Use My Index?

It may happen that we create an index, but PostgreSQL doesn’t use it. What could be the reason, and how can we fix it?

October 3, 2024

· 4,218 Views · 7 Likes

Indexes Under the Hood

One of the most obvious improvements for databases is to use indexes. Let's see them in detail to understand how they work in PostgreSQL and what makes them useful.

September 27, 2024

· 4,329 Views · 8 Likes

Concurrency Issues in SQL and Distributed Systems

What happens if the first transaction must be canceled later for any reason? How should this affect the other transaction? Read on to understand!

September 25, 2024

· 4,147 Views · 5 Likes

Troubleshooting PostgreSQL Low Free Memory

Gain an understanding of how databases (specifically PostgreSQL) manage memory and how to troubleshoot low free-memory scenarios.

September 17, 2024

· 5,193 Views · 6 Likes

What Are Logging Levels?

Many things can break, but when the logging breaks, then we are completely lost. In this article, understand how to log efficiently in distributed systems.

September 9, 2024

· 3,129 Views · 2 Likes

Configuring a Connection Pool

A connection pooler is a software component that manages database connections. In this post, learn what a connection pooler is and how to configure it.

September 3, 2024

· 2,800 Views · 3 Likes

Debugging Low Cache Hit Ratio

Explore debug scenarios where we can’t utilize cached data and need to read from the physical drive, why it's important, what to look for, and helpful tools.

August 27, 2024

· 1,984 Views · 2 Likes

Calculating Fingerprints for SQL Queries

Learn how to calculate a unique identifier for each SQL query in the database. See how we solved this challenge and what options we considered.

June 20, 2024

· 3,133 Views · 1 Like

How Enabling Slow Query Log Enhances Postgres Observability

Here, learn about the slow query log in PostgreSQL, a feature that allows you to log queries that take longer than a specified threshold to execute.

May 2, 2024

· 1,790 Views · 1 Like

Why DevOps Should Own Their Databases and How To Do It

It took us nearly 20 years to finally formulate the state of DevOps and bridge development and operations. However, we need to take another step to own the databases.

March 7, 2024

· 2,470 Views · 2 Likes

DORA Metrics in DevOps

DORA group defined four broad metrics that are now known as DORA Four Keys. Let's use them to measure the velocity and stability of our databases.

January 30, 2024

· 3,074 Views · 6 Likes

Transaction Isolation Levels For The Highest Possible Performance

Database transaction isolation levels let us get even better performance without rewriting our applications. See how they can be helpful and why we should care.

October 26, 2023

· 3,206 Views · 6 Likes

A New Era Has Come, and So Must Your Database Observability

We can't prevent the bad code from the deployment. We lack database observability, and we can't troubleshoot automatically. We need a new approach: database guardrails.

September 28, 2023

· 3,694 Views · 2 Likes

Comments

PostgreSQL Everywhere and for Everything

Oct 09, 2024 · Adam Furmanek

Thanks. Yet another great example of PG everywhere.

DORA Metrics in DevOps

Feb 08, 2024 · Adam Furmanek

Hi Rajesh. There are many tools you can use, for instance Metis, Dynatrace, Datadog, AppDynamics, or Jaeger. Mind that some of these overfocus on capturing signals and lack reasoning and troubleshooting. See this article to learn more: https://www.metisdata.io/blog/all-your-monitoring-solutions-are-just-wrong

The easiest is to take OpenTelemetry and wire it up in your infrastructure. I don't know what your tech stack is, but most applications should handle it pretty well.