Denny [DBA at Innervate]

Do you mean ``` ----> ReplicatedMergeTree ( OK. here indexes are used. ) / / select --->> Engine=Merge --- \ \ ----> View ---> ReplicatedMergeTree ( Not OK. here indexes...

`MemoryResident = 3.3 GB` Try to compare with RES/RSS from Linux OS process (top/htop/ps ). ClickHouseMetrics_MemoryTracking shows incorrect values.

Check this https://github.com/ClickHouse/ClickHouse/issues/33320 . Do you use "live views" ? What API/library do you use to query CH ?

check clickhouse-server.log for memory tracker messages. Check after which events CH allocates memory.

>Is this fixed on the most recent release? No. >Does anyone know if this issue also occurs in [Altinity releases](https://altinity.com/altinity-stable/)? Yes, the same behavior. Nobody is working on this, because...

>Isn't this happening on all kafka tables? I don't know. How come? >What do we need to provide for it to be reproducible? Configuration of Kafka. 1) broker version 2)...

@PhantomPhreak can you try `system drop mark cache` and share the new mem graph ?

>4th run 11.7 seconds, 5th run and so on: 11.7 secs. Are you aware about JIT compiler? It starts to work after `min_count_to_compile_expression=3` ```sql select name , value from system.settings...

I don't see a test ?

You can use `force_primary_key=1` and insert only 10 rows in the table. ```sql CREATE TABLE dt64_monot_test ( `date_time` DateTime64(3), `id` String ) ENGINE = MergeTree PARTITION BY toDate(date_time) ORDER BY...