On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote: > > > On 9/4/07, Ow Mun Heng <Ow.Mun.Heng@wdc.com> wrote: > Hi, > > I'm running out of space on one of my partitions and I still > have not > gotten all the data loaded yet. I've read that one could > symlink the > pg_pg_xlog directory to another drive. I'm wondering if I can > do the > same for specific tables as well. > > > Create another tablespace to the new location and the ALTER TABLE ... > TABLESPACE newtablespace. >
OOooohhh... I didn't know one could use tablespaces like that. (I mean, I did read the docs, but it just didn't register that it _can_ do something like that)
additional question.. do I need to change the search_path?
No (changing tablespaces does not change your logical schema).