Remove c
article thumbnail

Transparent Huge Pages Refresher

Percona

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages?

article thumbnail

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

Percona

As these fields do not contain sensitive data, this is not a security issue and helps with the performance and simplicity of the extension. This, with some additional information, is what gets stored in the.tde file: hexdump -C /tmp/tdedata/postgresql/data/base/5/16397.tde 00000010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |.|

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

Effective Concurrency: Prefer Using Active Objects Instead of Naked Threads

Sutter's Mill

This article will show how to implement the pattern, including a reusable helper to automate the common parts, in any of the popular mainstream languages and threading environments, including C++, C#/.NET, NET, Java, and C/Pthreads. Sep 2007). 3 Use Critical Sections (Preferably Locks) to Eliminate Races (Oct 2007).

C++ 40
article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. No secondary indexes means that point selects (select by ID) tend to be very slow.

article thumbnail

How To Measure the Working Set Size on Linux

Brendan Gregg

The tools use either the referenced or the idle page flags to measure a page-based WSS, and were developed out of necessity for another performance problem. ## Method 1: Referenced Page Flag This uses a kernel feature added in Linux 2.6.22: the ability to set and read the referenced page flag from user space, added for analyzing memory usage.

Cache 71
article thumbnail

Effective Concurrency: Prefer Using Futures or Callbacks to Communicate Asynchronous Results

Sutter's Mill

Finally, here are links to previous Effective Concurrency columns: 1 The Pillars of Concurrency (Aug 2007). Sep 2007). 3 Use Critical Sections (Preferably Locks) to Eliminate Races (Oct 2007). 4 Apply Critical Sections Consistently (Nov 2007). 17 Understanding Parallel Performance (Dec 2008).

Website 40
article thumbnail

Data Mining Problems in Retail

Highly Scalable

The goal is to find a set of the most promising candidates who should receive the resource in order to maximize the overall performance of the targeted group of customers. Moreover, gross margin is not the only performance metric that is important for retailers. The resource can be homogenous (i.e. Applications. Applications.

Retail 152