On Thu, Sep 18, 2008 at 2:13 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
freezing old tuples
hash join was spilling out to temp files
Since this was a new table and the writes to the table's disk were very large it was probably the hint bits.
The small table was about 1300 rows and my work_mem was 100MB so the writes to the main disk probably was not hash spillage. They were tiny, so I'm not worried about them.
