Re: What to do if space for database decrease and no additional hard drive is possible?

2010/7/26 A. Kretschmer <andreas.kretschmer@schollglas.com>:
> In response to Vincenzo Romano :
>> 2010/7/26 A. Kretschmer <andreas.kretschmer@schollglas.com>:
>> > In response to Ivan Voras :
>> >> * buy external storage (NAS, or even an external USB drive), move the
>> >> database to it
>> >
>> > buy external USB-Drive, and create a new tablespace, and move some large
>> > table into this new tablespace and/or use the new tablespace for new
>> > tables. You can also use table-partitioning with different tablespaces.
>>
>> Table space on a USB drive?
>> You must be really sinking for this very option!
>> I'd rather move everything else from the crowded partition onto the USB drive,
>> as I would suppose that the database (performance and reliability) is
>> more important by far ...
>
> Maybe, depends.... but why not? Maybe there are some big, but rarely
> used, read-only tables?

... or maybe not.
Better move other stuff away, IMHO.

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS