Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/7/26 A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx>:
> In response to Vincenzo Romano :
>> 2010/7/26 A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx>:
>> > 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux