Title
#users-public
Sergey Georgiev

Sergey Georgiev

08/22/2022, 12:14 PM
Hi all. How much operation memory is expected QuestDB to consume if I have 5GB data on the disk.
Bolek Ziobrowski

Bolek Ziobrowski

08/22/2022, 12:20 PM
Hi Sergey. It all depends on how complex queries you run. With sql it's possible to 'multiply 'dataset size and trigger materialization that'd end up using much more than 5GB of ram ( or disk).
Sergey Georgiev

Sergey Georgiev

08/22/2022, 12:29 PM
Yes. My experience show the same. Is there a way to reduce memory consumed from sql query in exchange of its speed. Slow query is acceptable.
Bolek Ziobrowski

Bolek Ziobrowski

08/22/2022, 12:37 PM
At the moment rewriting query and/or tweaking settings is the only way because qdb doesn't spill temporary data to disk. I could havea look if you share the schema and query .
Sergey Georgiev

Sergey Georgiev

08/22/2022, 12:57 PM
I will send you more information on private.