Re: [HACKERS] sort on huge table
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] sort on huge table |
Дата | |
Msg-id | 199911011832.NAA21398@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] sort on huge table (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [HACKERS] sort on huge table
|
Список | pgsql-hackers |
> Next question is what to do about it. I don't suppose we have any way > of turning off the OS' read-ahead algorithm :-(. We could forget about > this space-recycling improvement and go back to separate temp files. > The objection to that, of course, is that while sorting might be faster, > it doesn't matter how fast the algorithm is if you don't have the disk > space to execute it. If I am correct on the Linux seek thing, and Tatsuo is running Linux, is there any way to fake out the kernel on only Linux, so we issue two reads in a row before doing a seek? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: