Re: What to do if space for database decrease and no additional hard drive is possible? - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: What to do if space for database decrease and no additional hard drive is possible?
Date
Msg-id AANLkTim4d9ve12Ov7hf0PbYK7tOSuvHgtb5ZCz_THrDg@mail.gmail.com
Whole thread Raw
In response to Re: Re: What to do if space for database decrease and no additional hard drive is possible?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: What to do if space for database decrease and no additional hard drive is possible?
List pgsql-general
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 ...

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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Re: What to do if space for database decrease and no additional hard drive is possible?
Next
From: Bill Thoen
Date:
Subject: Re: Re: What to do if space for database decrease and no additional hard drive is possible?