Re: [HACKERS] sort on huge table

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, t-ishii(at)sra(dot)co(dot)jp, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] sort on huge table
Date: 1999-11-30 08:42:25
Message-ID: 38438DF1.FC547300@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Was this resolved?
>
> I tweaked the code some, and am waiting for retest results from Tatsuo.
>
> I think the poor results he is seeing might be platform-dependent; on
> my machine current code seems to be faster than 6.5.* ... but on the
> other hand I don't have the disk space to run a multi-gig sort test.
>
> Can anyone else take the time to compare speed of large sorts between
> 6.5.* and current code?

Is there a howto for running an additional development backend ?

If there is, I could test it on a dual P!!!500MHz IBM Netfinity
M20 with 1GB memory and >30 GB RAID5 disks.

---------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Theo Kramer 1999-11-30 10:25:22 Insert into view
Previous Message Hiroshi Inoue 1999-11-30 08:17:59 RE: [HACKERS] Re: [GENERAL] drop/rename table and transactions