Percona
AUGUST 29, 2023
Among its many capabilities, a Citus cluster can: Create distributed tables that are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage, and I/O capacity. Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables.
n0derunner
MARCH 13, 2020
To achieve the maximum throughput on a storage device, we will usually use a large IO size to maximize the amount of data is transferred per IO request. For historical reasons, many storage testers will use a 1MB IO size for sequential testing. 8 Sectors = 4KB 128 Sectors = 64KB 1024 Sectors = 512KB 2048 Sectors = 1024KB (1MB).
SQL Server According to Bob
JANUARY 11, 2020
The storage space that is required for the sparse file is only that of the actual bytes written to the file and not the maximum file size.
Expert insights. Personalized for you.
79 
Let's personalize your content