AW: AW: [HACKERS] sort on huge table

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SEV
Тема AW: AW: [HACKERS] sort on huge table
Дата
Msg-id 219F68D65015D011A8E000006F8590C60339E160@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: [HACKERS] Regression Testing on REL6_5_PATCHES
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] 6.5.3 is ready