| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | t-ishii(at)sra(dot)co(dot)jp, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] sort on huge table |
| Date: | 1999-10-19 03:17:37 |
| Message-ID: | 1724.940303057@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-10-19 04:13:31 | funny psql output |
| Previous Message | Tom Lane | 1999-10-19 03:10:54 | Re: [HACKERS] mdnblocks is an amazing time sink in huge relations |