Page 1 of 1

What Happens when using Direct Option in Copy , Insert, Update Command

Posted: Sat Mar 07, 2015 3:02 pm
by vigneshn
In Document it says Direct options allows data to be moved directly to WOS [ Secondary storage]. But How does it happen during processing. Sorry if I am wrong, According to the computer knowledge I have gained, the data cannot directly move to harddisk without passing main memory. If that is the case then what really happens when using Direct options. Please help me understand

Re: What Happens when using Direct Option in Copy , Insert, Update Command

Posted: Sun Mar 08, 2015 5:08 pm
by JimKnicely
Hi,

There is a resource pool named WOSDATA that is set up in main memory specifically to hold projection data prior to being written to disk. The default size is 2 GB.

Code: Select all

dbadmin=> select name, memorysize, maxmemorysize from resource_pools where name = 'wosdata';
  name   | memorysize | maxmemorysize
---------+------------+---------------
 wosdata | 2G         | 2G
(1 row)
I'd imagine that data would have to pass through the host's main memory modules via the Vertica process in some manner, but it won't be placed the the special WOS area.