Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group