"Kevin Grittner" <[EMAIL PROTECTED]> writes: > http://wiki.postgresql.org/wiki/Hint_Bits
On Thu, Sep 18, 2008 at 2:13 PM, Tom Lane <[EMAIL PROTECTED]> 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. Thanks very much, Nik