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 ... -- 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
