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