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