From: | Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Changing FS when full |
Date: | 2010-01-21 15:57:01 |
Message-ID: | 20100121155701.GL1687@bal740r0.mecon.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a big database on FS1, now almost full. Have space on FS2,
where I created a tablespace and moved every table and index to it.
Still, lots of space used on FS1. The problem is not pg_xlog, but
base:
# du -hs base/105658651/* | fgrep G
1,0G base/105658651/106377323
1,0G base/105658651/106377323.1
1,0G base/105658651/106377323.2
1,0G base/105658651/106377323.3
1,0G base/105658651/106377323.4
1,0G base/105658651/125520217
1,0G base/105658651/127352052
1,0G base/105658651/127352052.1
1,0G base/105658651/127352052.2
1,0G base/105658651/127352052.3
1,0G base/105658651/127352052.4
1,0G base/105658651/127352052.5
Unfortunately no volume management is available, so I can't move
disks from FS2 to FS1.
I could play soft links tricks, but I'm afraid of paying the
FS-traversal penalty on each file access (is that right?).
So, any way of instructing PG (8.1 if that matters) to place those
files elsewhere without an initdb?
Thanks!
Fernando.
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2010-01-21 16:17:58 | \dt+ sizes don't include TOAST data |
Previous Message | Yan Cheng Cheok | 2010-01-21 15:31:34 | Re: Partitioning on Table with Foreign Key |