Problem when adding a partition
We have had a table partitioned by month for years. We have a script that rolls the partition, dropping the oldest and adding a new one, each month. The script has run unchanged for well over a year. But suddenly adding the next partition causes problems. within 15 minutes of adding the new partiton the CPU load climbs to max and stays there for hours. Also query plans for some queries suddenly change and take a lot longer. Dropping the new empty partition gets us back to previous performance. Anyone seen anything like this? We update stats, distributions only, every day.
Version and platform and did anything change (like a version upgrade) since the last new partition was added wtihout problems? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 18, 2012 at 3:23 AM, SCOTT ROBERTS <sroberts20@csc.com> wrote: > We have had a table partitioned by month for years. We have a script that > rolls the partition, dropping the oldest and adding a new one, each month. > The > script has run unchanged for well over a year. > > But suddenly adding the next partition causes problems. within 15 minutes > of > adding the new partiton the CPU load climbs to max and stays there for > hours. > Also query plans for some queries suddenly change and take a lot longer. > Dropping the new empty partition gets us back to previous performance. > > Anyone seen anything like this? > > We update stats, distributions only, every day. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae934126304f92e04ca03da13