Re: [HACKERS] sort on huge table
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] sort on huge table |
Дата | |
Msg-id | 199911020241.VAA06661@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] sort on huge table (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
> Lamar Owen <lamar.owen@wgcr.org> writes: > > How could I go about duplicating this?? Having multiple RedHat systems > > available (both of the 2.2 and 2.0 variety), I'd be glad to test it > > here. I'm pulling a cvs update as I write this. If possible, I'd like > > to duplicate it exactly. > > Me too (modulo disk space issues --- maybe we should try to compare > sorts of say 100MB, rather than 2GB). Tatsuo said he'd make his test > script available. I would be very interested if Tatsuo could comment out the f_reada line in the function I posted, and see if the new kernel is faster on 7.0 sorts. That would clearly show the cause. I wouldn't be surprised if 7.0 sorts became faster than 6.5.* sorts. -- 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 по дате отправления: