Tom, Peter,
While I'm writing this guide ... where does PostgreSQL store temp files for queires which are too large for sort_mem? I can't seem to find docs on this.
-- -Josh Berkus Aglio Database Solutions San Francisco