openGauss NUMA Awareness Allocation and AffinityNon-Uniform Memory Access (NUMA) is a computer memory design used in multiprocessing, where the memory access time depends on the memory location relative to the processor. Under NUMA, a processor can take advantage of NUMA by preferring to access it...Apr 21, 2023·2 min read
openGauss MOT Local and Global MemorySILO manages both a local memory and a global memory, as shown in. Global memory is long-term shared memory is shared by all cores and is used primarily to store all the table data and indexes Local memory is short-term memory that is used primaril...Apr 21, 2023·1 min read
openGauss MOT Concurrency Control MechanismAfter investing extensive research to find the best concurrency control mechanism, we concluded that SILO based on OCC is the best ACID-compliant OCC algorithm for MOT. SILO provides the best foundation for MOT's challenging requirements. With the re...Apr 21, 2023·1 min read
openGauss MOT Scale-up ArchitectureTo scale up means to add additional cores to the same machine in order to add computing power. To scale up refers to the most common traditional form of adding computing power in a machine that has a single pair of controllers and multiple cores. Sca...Apr 21, 2023·5 min read
openGauss MOT Sample PGBench benchmarkpgbench is a simple program for running benchmark tests on PostgreSQL. It runs the same sequence of SQL commands over and over, possibly in multiple concurrent database sessions, and then calculates the average transaction rate (transactions per seco...Apr 21, 2023·1 min read
openGauss MOT Sample PGBench benchmarkpgbench is a simple program for running benchmark tests on PostgreSQL. It runs the same sequence of SQL commands over and over, possibly in multiple concurrent database sessions, and then calculates the average transaction rate (transactions per seco...Apr 21, 2023·1 min read
openGauss MOT Sample TPC-C BenchmarkPC-C Introduction The TPC-C Benchmark is an industry standard benchmark for measuring the performance of Online Transaction Processing (OLTP) systems. It is based on a complex database and a number of different transaction types that are executed on ...Apr 21, 2023·3 min read