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

From: AlannY <m(at)alanny(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What to do if space for database decrease and no additional hard drive is possible?
Date: 2010-07-26 10:43:47
Message-ID: f90d7f2ab5340a07da5f7c7b6ab5fed4@imap.hc.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there.

I have a huge database with several tables. Some tables have statistics
information. And it's very huge. I don't want to loose any of this data.
But hard drives on my single server are not eternal. Very soon, there will
be no left space. And the most awful this, that it's a 1U server, and I
can't install new hard drive.

What can I do to enlarge space, without loosing data and performance?

Thanks for patience.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2010-07-26 10:47:53 Re: Server load statistics
Previous Message Artur Dabrowski 2010-07-26 10:20:16 Re: Incorrect FTS result with GIN index