Failed to handle postgres query, code: EngineExecuteQuery, error: Too many files to read concurrently: 1763, max allowed: 384

[GutoGT]

Good afternoon everyone, after loading data into a table I receive the following error:

2025-10-17T16:14:30.907439Z ERROR servers::postgres::utils: Failed to handle postgres query, code: EngineExecuteQuery, error: Too many files to read concurrently: 1763, max allowed: 384 err=0: , at /rustc/4d051fb306e661654d088892e02e69b8c0c39d43\library\core\src\task\poll.rs:290:44
1: External(0: External error, at src\query\src\dist_plan\merge_scan.rs:323:22
1: Region query error, at src\frontend\src\instance\region_query.rs:57:14
2: Failed to query, at src\frontend\src\instance\region_query.rs:83:14
3: External error, at src\frontend\src\instance\standalone.rs:111:14
4: Failed to execute logical plan, at C:\a\greptimedb\greptimedb\src\datanode\src\region_server.rs:1247:14
5: , at src\query\src\datafusion.rs:352:29
6: Context("parallelize_scan", External(0: Too many files to read concurrently: 1763, max allowed: 384, at src\mito2\src\read\seq_scan.rs:597:14)))

table:

CREATE TABLE IF NOT EXISTS "analogicas_in" (
"ts" TIMESTAMP(3) NOT NULL,
"indice" INT NULL,
"valor" DOUBLE NULL DEFAULT 0,
TIME INDEX ("ts")
)

ENGINE=mito
WITH(
ttl = '9years 10months 8days 8h 24m'
);

[GutoGT]

After a while it started responding to SQL commands:

[evenyag]

This is a limit to protect the database against reading too many files into memory to deduplicate rows. You can enlarge this but it may cause the database using too much memory.

greptimedb/config/standalone.example.toml

Lines 577 to 578 in 938d757

	## Maximum number of SST files to scan concurrently.
	max_concurrent_scan_files = 384

After a while it started responding to SQL commands

There is also a background compaction job to merge small files and reduce the file num.