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 = *