View Single Post

   
  #2 (permalink)  
Old 04-19-2008, 08:27 PM
Neil Truby
 
Posts: n/a
Default Re: Adding space to a table fragmented with round robin

Buy more disk.
It's as cheap as chips.
Point out the small amount that extra disk would pale into comparison with
the enormous cost of your time!

Failing that, have you enough dowtime to re-fragment the table if you add a
new one?

Is the system only running for 3 months because it's then moving to SQL
Server or something?

--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby@ardenta.com


"Andy Kent" <andykent.bristol@virgin.net> wrote in message
news:a3525a11.0311180420.75c15591@posting.google.c om...
> I have a table of 20GB (of data - the indexes are detached),
> fragmented over 5 dbspaces which are all about to run out of space.
> We're on 7.3.
>
> Physical disk space is at a serious premium so I'd be reluctant to add
> a whole 2GB chunk to each dbspace. If I added chunks in smaller
> increments it would mess up their nice neat topography and I've no
> idea how long a given amount of space would last. (The system will
> only be running for another 3 months and consequently they have a
> budget for more disks of zero).
>
> Ideally I would like to simply add another 4GB fragment but I don't
> believe this is possible with round robin - is it?
>
> What strategy would the panel adopt?
>
> Thanks,
>
> Andy Kent



Reply With Quote