All Forums Database
yuvaevergreen 93 posts Joined 07/09
22 Jul 2014
Distribution in amps

Hi,
 In a system of 190 amps,Whenever I create a table 1 kb is assigned to each vproc by default summing to 190 kb. Why is this space assigned to each vproc. When I queried the allspace view, I am able to find this info.
 
Thanks,
yogi.
 
   

Santanu84 122 posts Joined 04/13
28 Jul 2014

Hi
When you create a table, table header is created across all amps. It consumes 1024 B for that.
Thanks
Santanu

yuvaevergreen 93 posts Joined 07/09
31 Jul 2014

Thanks....

dnoeth 4628 posts Joined 11/04
31 Jul 2014

The table header is not always 1 KB, in fact it's usually larger, might be up to 1 MB per AMP
The actual size per AMP depends on the number of columns & indexes, multi value compression, etc.

Dieter

You must sign in to leave a comment.