I use one resource pool: pool_id | 45035996273737108 name | queries is_internal | f memorysize | 8156M maxmemorysize | executionparallelism | AUTO priority | 0 runtimepriority | MEDIUM runtimeprioritythreshold | 2 queuetimeout | 300 plannedconcurrency | 80 maxconcurrency | 100 runtimecap | singleini...

Hi! I have troubles with cluster performance during load testing. I have some typical queries which are using projections and they execute in nice 50-60ms. Then I open about 150 connections and start to execute my queries in it periodically (~30 req/min per session, ~5000 req/min total). As a result...

One question is whether the INSERTs slowed down because they were queueing on the resource pools, or because system resources were truly pegged. But you definitely don’t want to load large amounts of data using individual INSERT statements. Use COPY - the files don’t need to be local to the server....

Hi! I faced a problem with very slow INSERTs. I made such test: create empty table with no projections and start inserting in it in batch, using INSERT INTO table SELECT 111,222,333 UNION ALL SELECT 444,555,666 UNION ALL SELECT 777,888,999; 1000 rows in one query On idle server one query runs about ...