| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-09-18 18:58:25 | Re: Why does this query write to the disk? |
| Previous Message | Scott Carey | 2008-09-18 18:33:31 | Re: Why does this query write to the disk? |