| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | AlannY <m(at)alanny(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What to do if space for database decrease and no additional hard drive is possible? |
| Date: | 2010-07-26 19:31:39 |
| Message-ID: | AANLkTinMVh9Qj9HZXHbiA7RREVbZ2or6WaYeL3xrOQ=C@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 26, 2010 at 4:43 AM, AlannY <m(at)alanny(dot)ru> wrote:
> 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?
So, what can you do? Can you add external storage or some kind? Get
access to a network mounted drive, at least temporarily? With the
restrictions you're listing I'm not sure you have a lot of
alternatives but to back up some of those tables, restore them
offsite, then drop the tables on the server.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2010-07-26 21:09:49 | Re: What to do if space for database decrease and no additional hard drive is possible? |
| Previous Message | Greg Smith | 2010-07-26 19:15:34 | Re: Re: What to do if space for database decrease and no additional hard drive is possible? |