Space Usage on Informix Question
Jack A asked how to avoid running out of space after purging old data, since the index dbspace was nearly full, and whether purging plus update statistics medium shrinks indexes. Jay Aymond said only dropping and recreating indexes reduces their space; update statistics does not. After purging there is less data in the index, but the tablespace does not shrink.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Whats the best way to make sure you dont run out of space on your machines ? I've set up some purge scripts which will purge a lot of old data on our system. That will free up space in the data dbspace and its corresponding chunk. But I see that the index dbspace and its chunk are very close to getting full. Is the only way to manage this to add an extra chunk ? Will purging data and running update stats medium shrink the indexes too ? TIA
The only way to reduce the space used by the indexes is to drop and recreate them. Running update statistics will not change the size of your tables or your indexes. "Jack A" <jacka8@excite.com> wrote in message news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranews.com... > Whats the best way to make sure you dont run out of space on your machines ? > I've set up some purge scripts which will purge a lot of old data on our > system. That will free up space in the data dbspace and its corresponding > chunk. But I see that the index dbspace and its chunk are very close to > getting full. Is the only way to manage this to add an extra chunk ? Will > purging data and running update stats medium shrink the indexes too ? > > TIA > >
Not even after purging the data ? Shouldnt a lower density of data result in a sparser index ? "Jay Aymond" <jaymond@communitycoffee.com> wrote in message news:BbWcnaTYYtKu59uiXTWJkw@eatel.net... > The only way to reduce the space used by the indexes is to drop and recreate > them. Running update statistics will not change the size of your tables or > your indexes. > > > "Jack A" <jacka8@excite.com> wrote in message > news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranews.com... > > Whats the best way to make sure you dont run out of space on your machines > ? > > I've set up some purge scripts which will purge a lot of old data on our > > system. That will free up space in the data dbspace and its corresponding > > chunk. But I see that the index dbspace and its chunk are very close to > > getting full. Is the only way to manage this to add an extra chunk ? Will > > purging data and running update stats medium shrink the indexes too ? > > > > TIA > > > > > >
There will be less data in the index tablespace, but the physical size of the tablespace holding the index will not shrink. "Jack A" <jacka8@excite.com> wrote in message news:f42231c99c1f73e617d3a78b080c21da@news.teranews.com... > Not even after purging the data ? Shouldnt a lower density of data result in > a sparser index ? > > "Jay Aymond" <jaymond@communitycoffee.com> wrote in message > news:BbWcnaTYYtKu59uiXTWJkw@eatel.net... > > The only way to reduce the space used by the indexes is to drop and > recreate > > them. Running update statistics will not change the size of your tables > or > > your indexes. > > > > > > "Jack A" <jacka8@excite.com> wrote in message > > news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranews.com... > > > Whats the best way to make sure you dont run out of space on your > machines > > ? > > > I've set up some purge scripts which will purge a lot of old data on our > > > system. That will free up space in the data dbspace and its > corresponding > > > chunk. But I see that the index dbspace and its chunk are very close to > > > getting full. Is the only way to manage this to add an extra chunk ? > Will > > > purging data and running update stats medium shrink the indexes too ? > > > > > > TIA > > > > > > > > > > > >