"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
On Thu, Sep 18, 2008 at 2:13 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.
Thanks very much,
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2008-09-18 18:58:25|
|Subject: Re: Why does this query write to the disk? |
|Previous:||From: Scott Carey||Date: 2008-09-18 18:33:31|
|Subject: Re: Why does this query write to the disk?|