Re: [HACKERS] sort on huge table

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: t-ishii(at)sra(dot)co(dot)jp, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] sort on huge table
Date: 1999-10-19 08:49:22
Message-ID: 199910190849.RAA29403@srapc451.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-19 09:00:19 Re: [HACKERS] funny psql output
Previous Message Victoria W. 1999-10-19 06:17:15