"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

Reply via email to