Percona

DECEMBER 5, 2023

The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 While we’ve contemplated taking a physical backup and conducting PITR , it’s worth noting that PITR can also be executed on the existing replica or delayed replica to expedite the process.

Database 76

Database Traffic C++ Servers 76

SQL Performance

APRIL 14, 2021

It has excellent performance, and there’s quite a lot that you can learn from it. Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Let’s examine the plans for two of the earlier solutions that utilized batch processing.

C++ 112

C++ Servers Testing Code 112

Particular Software

MARCH 28, 2022

With a saga, a business process that would otherwise have been implemented as a clunky batch job 1 can be built in a much more elegant and real-time manner. Saga analyzers Sagas have a powerful API, but it’s limited by the confines of C#. You can create a class that is a lousy saga but is still perfectly valid C# code.

Development 52

Development C++ Virtualization Metrics 52

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. A change to such parameters requires the postmaster — the main process of the PostgreSQL — to restart. If, at all, there is any crash in between, I am OK to perform the ETL again. Type "help" for help.

Database 101

Database Servers Open Source Tuning 101

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Well, I’m oversimplifying a bit.

C++ 109

C++ Database Servers Code 109

O'Reilly

DECEMBER 12, 2023

This ruling in itself raises many questions: how much creativity is needed, and is that the same kind of creativity that an artist exercises with a paintbrush? But reading texts has been part of the human learning process as long as reading has existed; and, while we pay to buy books, we don’t pay to learn from them.

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

SQL Performance

JUNE 10, 2020

This month and the next I’m going to cover the physical processing aspects of derived tables. That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? Well, I’m oversimplifying a bit.

C++ 93

C++ Database Servers Code 93

Tasktop

FEBRUARY 1, 2021

In a project organization, this flow is spread across teams, functions, tools, processes and even external parties like vendors. Carving out the relevant pieces for each product is an iterative process. The more this process encroaches on the status quo, the more resistance you will encounter. . Measuring the Flow.

Logistics 52

Logistics Metrics Architecture Software 52

The Agile Manager

AUGUST 31, 2021

If we accept the fact that Agile is a value system and not a set of mechanical processes, it stands to reason that there must be something different about the norms and behaviors of Agile managers vis-a-vis traditional managers. One person who does a substandard job affects the performance of the entire team.

Metrics 52

Metrics Design Engineering C++ 52

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

Simplifying the Development Process with Mock Environments. The key to meeting these challenges is to process incoming telemetry in the context of unique state information maintained for each individual data source. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript).

Cloud 52

Cloud Development Analytics Azure 52

Tasktop

OCTOBER 29, 2020

Beneath the question lies a fear — always legitimate, but especially so in a year of economic distress and highly constrained budgets — that a VSM tool will simply expose what is already known: “Our processes, workflows and tools are a mess. After we’ve cleaned up our act and matured our processes, we’ll finally be ready for a VSM tool.” .

Storage 52

Storage Speed C++ DevOps 52

The Morning Paper

DECEMBER 8, 2019

At the start of November I was privileged to attend HPTS (the High Performance Transaction Systems) conference in Asilomar. With NVM we have both an opportunity to avoid serialisation overheads, and also an obligation since these overheads would be intolerable compared to the performance of NVM. Early performance results.

Hardware 56

Hardware Programming Media Storage 56

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

The Agile Manager

APRIL 26, 2010

A leaned-out IT organization capitalizing a significant proportion of its discretionary spend is highly susceptible to a perfect storm of (a) SG&A contraction, (b) IT project write-off, and (c) suspended IT investments. Capitalizing development of IT assets is an exercise in funding salaries and contractor costs out of CapEx budgets.

Government 49

Government Efficiency C++ Software 49

All Things Distributed

NOVEMBER 15, 2010

This incredible power is available for anyone to use in the usual pay-as-you-go model, removing the investment barrier that has kept many organizations from adopting GPUs for their workloads even though they knew there would be significant performance benefit. The different stages were then load balanced across the available units.

AWS 136

AWS Latency Programming Architecture 136