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? I noticed that when I create a
new index etc, it will hit the os disk (that's where the main tablespace
is located but no data is actually being stored there except for PG's
template1/0 etc table)
I would rather it hit the Raid Array. I looked at the postgres.conf file
but didn't see anything obvious to point out the temp location..