"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes:
> http://wiki.postgresql.org/wiki/Hint_BitsOn Thu, Sep 18, 2008 at 2:13 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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
