BestHub
Sign in
StarRocks
StarRocks
Dec 11, 2025 · Databases

How StarRocks Redesigns Bulk Import to Cut Small Files and Boost Throughput

This article explains how StarRocks mitigates the hidden risks of massive one‑time data imports in a storage‑compute separated architecture by redesigning the write path to spill to local disk, merge centrally, and write to object storage, resulting in fewer small files, higher write throughput, and more stable query performance.

Bulk ImportStarRocksStorage Compute Separation
0 likes · 12 min read
How StarRocks Redesigns Bulk Import to Cut Small Files and Boost Throughput
Programmer DD
Programmer DD
Aug 27, 2022 · Databases

Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading

When loading massive amounts of data into PostgreSQL, disabling autocommit, postponing index and foreign‑key creation, adjusting memory settings, using COPY or pg_bulkload, and fine‑tuning WAL and trigger settings can dramatically improve import speed and overall performance.

Bulk ImportPerformance TuningPostgreSQL
0 likes · 7 min read
Top 10 PostgreSQL Bulk Import Optimizations for Faster Data Loading