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

From Zeugswetter Andreas SEV
Subject AW: AW: [HACKERS] sort on huge table
Date
Msg-id 219F68D65015D011A8E000006F8590C60339E160@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> Zeugswetter Andreas SEV <ZeugswetterA@wien.spardat.at> writes:
> > This new test case is not big enough to show cache memory 
> contention,
> > and is thus faster with the new code.
> 
> Cache memory contention?  I don't think so.  Take a look at the CPU
> versus elapsed times in Tatsuo's prior report on the 2Gb case.
> I'm not sure yet what's going on, but it's clear that the 
> bottleneck is
> I/O operations not processor/memory speed.

Yes, I doubt that the new test shows the same bottleneck situation.
He did not tell us the IO versus CPU time on the recent 250 Mb test.
I suspect, that the CPU time now has a higher percentage on total time.

Andreas


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [HACKERS] Regression Testing on REL6_5_PATCHES
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 6.5.3 is ready