I have problem with memory deallocation. look at the following queries
1- create table test01(a) as select generate_series(1,100000000)::int8 ;
2- create table test02(a) as select generate_series(1,100000000) ;
In execution of first query, memory usage increase rapidly until the transaction comes to end and deallocate all the memory which allocated with palloc.
I have wondered why all the memory deallocated at the end, so the cast is removed and query executed again. memory usage was not the same. It was grow very slow.
I need help to find the right point to deallocate the memory,