Hello Matthias and Janardhan, thank you very much for your replies.
The dataset I tried is indeed quite small. It is a csv of 506 rows * 14 columns (49.1 kb). I'll try with a bigger one and check the memory estimates again. Thanks again, Nantia 2017-09-05 0:05 GMT+03:00 Matthias Boehm <mboe...@googlemail.com>: > Hi Nantia, > > that's a good question - if your input data is very small, there is nothing > to worry about. For the explain output, the memory estimates are rounded to > MB. Therefore, whenever your input is less than 65,536 cells (dense), you > will see a memory estimate of 0 MB (e.g., round(65,535*8/(1,024*1,024)) = > 0). > > Regards, > Matthias > > On Mon, Sep 4, 2017 at 2:24 AM, Nantia Makrynioti <nantiam...@gmail.com> > wrote: > > > Hello, > > > > I generated a HOP plan and memory estimates for the input data of HOP > > operators are all 0MB. The code runs locally and the execution type is > CP. > > What could be the case where memory is estimated to 0MB? > > > > Thank you very much, > > Nantia > > >
