I'm detailing here the optimization performed on the Nebulous and gpc1 databases in march 2011.

Nebulous Optimization

• Run as ipp on ippdb00 within a screen session
• Each table was optimized one after the other See attached log file: log.nebulous.optimization
• Size variation (unfortunately I didn't record all the tables):

	#elements	Size after	Size before
Table name	in table	opt.(bytes)	opt.(bytes)

---

cabinet	8
deleted	510597
directory	5264597
instance	439024114	156091023360	204308742144	-24%
lock_record	0
log	0
mountedvol	49
storage_object	390559412	165691785216	204665257984	-20%
storage_object_attr	390559412
storage_object_xattr	53272583
volume	52

GPC1 Optimization