Percona

DECEMBER 5, 2023

The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 p 5432 -S slot_logical_upgrade -R -c fast -Xs -P -D /data/PG12_new -C 32610/32610 kB (100%), 1/1 tablespace 8. to PostgreSQL v15.4. Create a REPLICATION SLOT Create a replication slot to capture changes.

Database 76

Database Traffic C++ Servers 76

Sutter's Mill

JANUARY 11, 2021

C++20 supports two main assertion facilities… For each one, briefly summarize how it works, when it is evaluated, and whether it is possible for the programmer to specify a message to be displayed if the assertion fails. 5] For conditions, it’s up to us to make sure it’s true.) see question 4) if NDEBUG is not set. Bonus: [[assert: ?

C++ 58

C++ Programming Code Testing 58

SQL Performance

APRIL 14, 2021

I’ll do my testing in tempdb, enabling I/O and time statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS TIME , IO ON ; Limitations of earlier ideas. Use the following code to test the function with the variable assignment technique: DECLARE @n AS BIGINT ; SELECT @n = n FROM dbo. Well, he did , and it’s fascinating!

C++ 112

C++ Servers Testing Code 112

Sutter's Mill

JANUARY 25, 2021

That’s true whether we’re enabling checking at test time (e.g., Some conditions are so expensive that we may never check them without a good reason, even in testing. The first place to look for the bug is in this same function, because if prior contracts were well tested then likely this function created the first unexpected state.

C++ 45

C++ Programming Cache Testing 45

Sutter's Mill

JUNE 3, 2021

Briefly, what is the difference among: (a) undefined behavior Undefined behavior is what happens when your program tries to do something whose meaning is not defined at all in the C++ standard language or library (illegal code and/or data). its results if call sites call it in a way that violates the precondition the assertion is testing.

C++ 54

C++ Programming Lambda Code 54

HammerDB

JULY 16, 2021

The way we measure this is through a ‘performance profile’ This simply means that we run a series of tests incrementally increasing the system load until we find the peak performance. Plotting these data points enables us to understand the scalability of the database software being tested on that system. and MySQL 8.0.25

Virtualization 57

Virtualization Performance C++ Database 57

HammerDB

APRIL 19, 2023

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. We will not concern ourselves with the raw throughput of workload.

Performance 54

Performance Benchmarking Cache Storage 54

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. psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) Here is an example of the function definition to test the function-level settings. Type "help" for help.

Database 102

Database Servers Open Source Tuning 102

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? I can also ask for a reading list about plagues in 16th century England, algorithms for testing prime numbers, or anything else. We have provenance.

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

ScaleOut Software

AUGUST 20, 2020

Development is fast and straightforward using standard object-oriented techniques, and the test/debug cycle is kept short by making use of a mock environment running on the developer’s workstation. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). What Are Real-Time Digital Twins?

Cloud 52

Cloud Development Analytics Azure 52

ScaleOut Software

AUGUST 20, 2020

Development is fast and straightforward using standard object-oriented techniques, and the test/debug cycle is kept short by making use of a mock environment running on the developer’s workstation. They make use of standard object-oriented concepts and languages (such as C#, Java, and JavaScript). What Are Real-Time Digital Twins?

Cloud 52

Cloud Development Analytics Azure 52

The Agile Manager

MAY 31, 2021

A value-generative investment is an exercise in deploying risk capital through IT in the pursuit of extraordinary benefit that yields competitive advantage. But many a C-level exec has been fired for cost overruns on utility investments. This does not describe legacy modernization.

C++ 52

C++ Efficiency Systems Technology 52

SQL Performance

JUNE 10, 2020

Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. For example, when the inner query joins tables with common column names, like in the following example: SELECT custid , companyname , orderdate , orderid , rownum FROM ( SELECT *, ROW_NUMBER ( ) OVER ( PARTITION BY C. Orders AS O ON C.

C++ 109

C++ Database Servers Code 109

Sutter's Mill

MARCH 25, 2021

Some of these are exercised by the “wrong order” permutations above, but even call sites that remember the right argument order can make mistakes about the actual values. But is (b) always better than (c), in other examples? c) A pointer that is not null void f( int* p ) [[pre( p != Consider using a class instead.

C++ 45

C++ Design Code Systems 45

The Agile Manager

AUGUST 31, 2021

The obvious conclusions are (a) every individual drives to the collective output of the team; (b) every individual must strive to perform a high state of excellence; and (c) a team cannot maintain a level of performance any higher than the level of excellence achieved by its weakest performing member.

Metrics 52

Metrics Design Engineering C++ 52

SQL Performance

JUNE 10, 2020

Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. For example, when the inner query joins tables with common column names, like in the following example: SELECT custid , companyname , orderdate , orderid , rownum FROM ( SELECT *, ROW_NUMBER ( ) OVER ( PARTITION BY C. Orders AS O ON C.

C++ 93

C++ Database Servers Code 93

HammerDB

JANUARY 5, 2019

If you change something and re-run the same test the difference in the results can be attributed to the changes you made. Consequently over time you have a reference point “set in stone” from which future changes can be measured by running the same test. Scalability. can you be sure that it scales?

Benchmarking 40

Benchmarking Database Social Media Scalability 40

SQL Server According to Bob

FEBRUARY 10, 2019

512 byte response (use database context xxxxxx, default language xxxxxxx, test size xxxxx). – -c the control file. The following is a simple query for looking at the rate of login and logouts the test is accomplishing. The following is a simple query for looking at the rate of login and logouts the test is accomplishing.

Servers 40

Servers Network Database Systems 40

John McCalpin

JANUARY 22, 2018

There was no deep goal — just a desire to see the maximum GFLOPS in action. The exercise seemed simple enough — just fix one item in the Colfax code and we should be finished. Single-core testing with the same DGEMM routine showed maximum values of just under 72% of the nominal peak (about 90% of “adjusted peak”).

Latency 40

Latency Hardware Code Testing 40