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

From Tom Lane
Subject Re: [HACKERS] sort on huge table
Date
Msg-id 1724.940303057@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] sort on huge table  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
I wrote:
> 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.

That's what I get for not testing the interaction between logtape.c
and buffile.c at a segment boundary --- it didn't work, of course :-(.
I rebuilt with a small RELSEG_SIZE and debugged it.  I'm still concerned
about possible integer overflow problems, so please update and try again
with a large file.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] mdnblocks is an amazing time sink in huge relations
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Another historical message from the early days of PostgreSQL development