Kbase P10645: What is a good extent size to use for database extents?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/10/2003 |
|
Status: Unverified
GOAL:
What is a good extent size to use for database extents?
FACT(s) (Environment):
Progress 9.x
FIX:
A terabyte is on the large size for an extent.
Less than that is OK. One or two gigabytes is recommended.
A more useful question is whether you are running a discrete set of
RAID 1+0 disks. Large EMC arrays may well
have different characteristics than a stack of drives in your
system machine, especially if the EMC (or other SAN) is shared by
other systems. Homework on the storage system characteristics
is a must.
Try using largefiles for extents. You will get good performance
and many file handles back (important for Solaris).