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