Re: [HACKERS] sort on huge table - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] sort on huge table
Date
Msg-id 199910190849.RAA29403@srapc451.sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] sort on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] sort on huge table  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Victoria W."
Date:
Subject: ...
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] funny psql output