Re: Symlinking (specific) tables to different Drives

On 9/4/07, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> wrote:
>
> On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote:
> >
> >
> > On 9/4/07, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)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).

Regards

MP