Re: Btree indexes temp copy Was [Re: Cluster using tablespaces?]

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> writes:
> On Wed, 2007-11-28 at 18:30 -0500, Tom Lane wrote:
>> For btree indexes, there is a temporary copy of the index data, which
>> will go wherever you have arranged for temp files to go.  (I think that
>> easy user control of this may be new for 8.3, though.)

> In 8.2.5 is there a way to control this?

You can replace the pgsql_tmp subdirectory with a symlink to someplace.

This is outside the purview of the database, so for instance it won't
survive a dump/reload, but it can be a workable hack ...

			regards, tom lane