Remove 2008 Remove Processing Remove Storage Remove Tuning
article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Consolidate workloads: In the past, you might have wanted to split out additional replicas or cluster nodes to process specific types of workloads, such as those related to reporting. If needed, you can spin up a backup.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. The Sort only has 19 rows to process, so it consumes only 1ms or so. Not everyone will be able to move to column store storage quickly, and it won't always be the right solution anyway. Test Environment. Final Thoughts.

Servers 86
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

Should You Use ClickHouse as a Main Operational Database?

Percona

Processed 4.15 Processed 4.15 Processed 8.19 Processed 8.19 Processed 4.15 In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel. Processed 3.05 Processed 8.19

article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls). amazon").

article thumbnail

Structural Evolutions in Data

O'Reilly

It progressed from “raw compute and storage” to “reimplementing key services in push-button fashion” to “becoming the backbone of AI work”—all under the umbrella of “renting time and storage on someone else’s computers.” ” (It will be easier to fit in the overhead storage.)

Hardware 102
article thumbnail

Real-Real-World Programming with ChatGPT

O'Reilly

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.