33 docs tagged with "beginner"

In some cases, we need to observe some values in Postgres or the environment it's running on (OS, FS, etc.), and:

Benchmarking is a huge topic. Here, we cover minimal steps that are required for a Postgres benchmark to be informative, useful, and correct.

Identify and handle long-running transactions that can impact OLTP system performance

In a few hours, I'm presenting my "Seamless Postgres query optimization" tutorial at DjangoCon US, so it's a good time to talk about transitioning from…

#PostgresMarathon day 2. Let's discuss PostgreSQL shutdown and restarts. It's not uncommon to see quite long and even failed shutdown/restart attempts.

#PostgresMarathon day 3. In the previous how-to, we discussed how to quickly stop or restart PostgreSQL.

Today we'll discuss how to understand what exactly a Postgres backend is doing inside CPU on a Linux machine (in-CPU analysis).

Understand subtransactions, savepoints, and their impact on database performance

There are two big branches of query optimization:

Today, we'll discuss tuples and their locations in pages – this is quite entry-level material but useful in many cases.