On 2010-01-21, Fernando Schapachnik wrote:
> 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/*
En un mensaje anterior, Greg Smith escribió:
> >So, any way of instructing PG (8.1 if that matters) to place those
> >files elsewhere without an initdb?
> >
>
> You can create another table just like the original on a tablespace
> using the new storage, drop the original, and then rename the n
Fernando Schapachnik wrote:
I could play soft links tricks, but I'm afraid of paying the
FS-traversal penalty on each file access (is that right?).
Compared to everything else that goes into I/O, symlink traversal
overhead is pretty low.
So, any way of instructing PG (8.1 if that matters)
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,0Gbase/105658651/106377323
1,0Gbase/10
