Alex Pelagenko

The default configuration allocates around 32+Mb of RAM per column. In your case of 10k columns it results to 320Gb total RAM reserved for writing only. It is excessive and...

@lg31415 Thanks for submitting the issue, it was very useful to realise that the memory usage is far from optimal. Sorry I couldn't provide you an immediate solution or workaround

#### [PR Coverage check] :heart_eyes: **pass** : 3 / 3 (100.00%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/griffin/model/QueryModel.java|2|2|100.00%| |:large_blue_circle:|io/questdb/griffin/SqlOptimiser.java|1|1|100.00%|

#### [PR Coverage check] :heart_eyes: **pass** : 25 / 25 (100.00%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/cairo/TxWriter.java|5|5|100.00%| |:large_blue_circle:|io/questdb/cairo/CairoEngine.java|1|1|100.00%| |:large_blue_circle:|io/questdb/cairo/TableWriter.java|19|19|100.00%|

Can you please elaborate? This issue will require examples of the data, query and expected result.

#### [PR Coverage check] :heart_eyes: **pass** : 3006 / 3247 (92.58%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/cairo/wal/DefaultWalApplyWorkerPoolConfiguration.java|0|2|00.00%| |:large_blue_circle:|io/questdb/cairo/wal/WalDataCursor.java|0|1|00.00%| |:large_blue_circle:|io/questdb/cairo/wal/WalUtils.java|0|1|00.00%| |:large_blue_circle:|io/questdb/log/LogFactory.java|0|9|00.00%| |:large_blue_circle:|io/questdb/cairo/wal/SequencerMetadataWriterBackend.java|0|10|00.00%| |:large_blue_circle:|io/questdb/cairo/vm/api/NullMemory.java|0|1|00.00%| |:large_blue_circle:|io/questdb/DefaultServerConfiguration.java|0|2|00.00%| |:large_blue_circle:|io/questdb/cairo/vm/MemoryCMARWImpl.java|2|6|33.33%| |:large_blue_circle:|io/questdb/cairo/ColumnType.java|2|4|50.00%| |:large_blue_circle:|io/questdb/cairo/vm/api/MemoryMA.java|2|4|50.00%| |:large_blue_circle:|io/questdb/std/ConcurrentHashMap.java|120|182|65.93%|...

#### [PR Coverage check] :heart_eyes: **pass** : 1 / 1 (100.00%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/griffin/engine/functions/table/TouchTableFunctionFactory.java|1|1|100.00%|

Negative values are not yet supported https://github.com/questdb/questdb/issues/2509

The PR has been inactive for a very long time. I am closing it for now, feel free to re-open when there are updates.

Similar to #3312