Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] sort on huge table - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] sort on huge table
Date
Msg-id 25042.940257292@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] sort on huge table  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> If you could try sorting a table larger than 4GB with this code, I'd be
>> much obliged.

> ERROR:  ltsWriteBlock: failed to write block 131072 of temporary file
>                 Perhaps out of disk space?

Drat.  I'll take a look --- thanks for running the test.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Jacek Witczak"
Date:
Subject: problem with PostgreSQL and LAN
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] is it possible to use LIMIT and INTERSECT ?