Chapter 4 – Deep Dive Inside a Netezza Extent and Row
“Write a wise saying and your name will live forever.”
Netezza Performance – Three Things to Keep in Mind
Follow these three rules, and you will have a well oiled machine. This chapter will explain in detail exactly how to do it.
How Netezza Allocates Data Storage
The first thing to understand is that when data is first being loaded to a table, each SPU automatically allocates 3 MB of disk space. When the data assigned to that SPU fills up the 3 MB extent, then Netezza allocates ...