Remove Cache Remove Code Remove Definition Remove Servers
article thumbnail

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Scalegrid

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246
article thumbnail

Radically speed up your code by fixing slow or frequent garbage collection

Dynatrace

Optimize your code by finding and fixing the root cause of garbage collection problems. These details arm you with the knowledge necessary to find the respective code and remove unnecessary allocations. Any significant reduction in allocations will inevitably speed up your code. You can even look at the source code directly. .

Speed 165
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

The road to observability with OpenTelemetry demo part 1: Identifying metrics and traces

Dynatrace

When software runs in a monolithic stack on on-site servers, observability is manageable enough. While classic logging is an essential tool in debugging issues, it often lacks context and only provides snapshot information of one specific location in your code/application. Those are prime candidates for their own spans.

Metrics 177
article thumbnail

A New Pattern For The Jamstack: Segmented Rendering

Smashing Magazine

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering.

Cache 114
article thumbnail

Understanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation

Percona

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. Per-Row Execution : For each affected row, the trigger’s code is executed. What is a Trigger in MySQL?

Cache 62
article thumbnail

Book Review: PostgreSQL 14 Internals by Egor Rogov

Percona

This book has five major sections on MVCC and Isolation (108 pages), Buffer Cache and WAL (53 pages), Locks (42 pages), Query Execution (154 pages), and the types of indexes (127 pages). The illustrations are clear, and there are many reference pointers to the documentation or source code where needed.

Cache 90
article thumbnail

Measure What You Impact, Not What You Influence

CSS Wizardry

What if another file on the critical path had dropped out of cache and needed fetching from the network? We can take reasonable measures (always refresh from a cold cache; throttle to a constant network speed), but we can’t account for everything. What if we incurred a DNS lookup this time that we hadn’t the previous time?