Skip site navigation (1) Skip section navigation (2)

Re: Why does this query write to the disk?

From: "Nikolas Everett" <nik9000(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Why does this query write to the disk?
Date: 2008-09-18 18:44:27
Message-ID: d4e11e980809181144v20994c62g49002f2dc4725803@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> http://wiki.postgresql.org/wiki/Hint_Bits


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,
Nik

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-09-18 18:58:25
Subject: Re: Why does this query write to the disk?
Previous:From: Scott CareyDate: 2008-09-18 18:33:31
Subject: Re: Why does this query write to the disk?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group