On Mon, Jul 26, 2010 at 4:43 AM, AlannY <m@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
