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
