Re: [HACKERS] sort on huge table
От | Tatsuo Ishii |
---|---|
Тема | Re: [HACKERS] sort on huge table |
Дата | |
Msg-id | 199910190849.RAA29403@srapc451.sra.co.jp обсуждение исходный текст |
Ответ на | Re: [HACKERS] sort on huge table (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [HACKERS] sort on huge table
Re: [HACKERS] sort on huge table Re: [HACKERS] sort on huge table |
Список | pgsql-hackers |
>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. It worked with 2GB+ table but was much slower than before. Before(with 8MB sort memory): 22 minutes After(with 8MB sort memory): 1 hour and 5 minutes After(with 80MB sort memory): 42 minutes. -- Tatsuo Ishii
В списке pgsql-hackers по дате отправления: