title: PostgreSQL - How to change tmp directory?
body: <p>I am running PostgreSQL on Windows 8 using the OpenGeo Suite.  I'm running out of disk space on a large join.  How can I change the temporary directory where the "hash-join temporary file" gets stored?</p>
  
  <p>I am looking at the PostgreSQL configuration file and I don't see a tmp file directory.</p>
  
  <p>Note: I am merging two tables with 10 million rows using a variable text field which is set to a primary key.</p>
  
  <p>This is my query:</p>
  
  <pre><code>UPDATE blocks 
  SET "PctBlack1" = race_blocks."PctBlack1"
  FROM race_blocks
  WHERE race_blocks.esriid = blocks.geoid10
  </code></pre>