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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] mdnblocks is an amazing time sink in huge relations
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [HACKERS] Another historical message from the early days of PostgreSQL development