Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does this query write to the disk? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why does this query write to the disk?
Date
Msg-id 24980.1221764305@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why does this query write to the disk?  ("Scott Carey" <scott@richrelevance.com>)
List pgsql-performance
Tree view 
"Scott Carey" <scott@richrelevance.com> writes:
> Under what conditions does EXPLAIN ANALYZE report spilling work_mem to
> disk?

For hash joins, it doesn't.  You might be thinking of the additional
reporting we added for sorts recently; but there's no comparable
logging for hash ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "Nikolas Everett"
Date:
Subject: Re: Why does this query write to the disk?
Next
From: Greg Smith
Date:
Subject: Re: RAID arrays and performance