Re: query produces 1 GB temp file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: query produces 1 GB temp file
Date: 2005-02-05 23:01:03
Message-ID: 190.1107644463@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Am I wrong? I thought the disk sort algorithm was the polyphase tape sort from
> Knuth which is always reading two tapes and writing to a third.

It is a polyphase sort, but we recycle the input "tapes" as fast as we
use them, so that the maximum disk space usage is about as much as the
data volume to sort.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dirk Lutzebaeck 2005-02-06 13:27:17 Re: query produces 1 GB temp file
Previous Message Greg Stark 2005-02-05 22:50:13 Re: query produces 1 GB temp file