Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
