Re: [HACKERS] sort on huge table
| От | Tom Lane |
|---|---|
| Тема | Re: [HACKERS] sort on huge table |
| Дата | |
| Msg-id | 1724.940303057@sss.pgh.pa.us обсуждение |
| Ответ на | Re: [HACKERS] sort on huge table (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [HACKERS] sort on huge table
|
| Список | 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 по дате отправления: