What's the block size when using ENCODING BLOCK_DICT

Moderator: NorbertKrupa

Post Reply
wqhhust
Newbie
Newbie
Posts: 3
Joined: Tue Nov 05, 2013 7:04 am

What's the block size when using ENCODING BLOCK_DICT

Post by wqhhust » Wed Nov 06, 2013 7:14 am

Per the document:
ENCODING BLOCK_DICT
For each block of storage, HP Vertica compiles distinct column values into a dictionary and then stores the dictionary and a list of indexes to represent the data block.

What's he size of block here? The block of the file system which is typically 4K or some block inside veritca which is much large(if so what's the size)?

pborne
Newbie
Newbie
Posts: 20
Joined: Mon Feb 18, 2013 1:37 am

Re: What's the block size when using ENCODING BLOCK_DICT

Post by pborne » Fri Jan 03, 2014 5:53 pm

By default, all the encoding is done on a block of 8,192 values. Depending on the data type, this works out to different block sizes in bytes.

Post Reply

Return to “New to Vertica Database Administration”