Re: Hardware/OS recommendations for large databases (

Поиск
Список
Период
Сортировка
Искать
От
Luke Lonergan
Тема
Re: Hardware/OS recommendations for large databases (
Дата
Msg-id
BFB0BF1B.1495C%llonergan@greenplum.com
Ответ на
Список
Дерево обсуждения
Re: Hardware/OS recommendations for large databases ( "Merlin Moncure" <merlin.moncure@rcsonline.com>
Re: Hardware/OS recommendations for large databases ( Mark Kirkwood <markir@paradise.net.nz>
Re: Hardware/OS recommendations for large databases ( "Luke Lonergan" <llonergan@greenplum.com>
Re: Hardware/OS recommendations for large databases ( Brendan Duddridge <brendan@clickspace.com>
Re: Hardware/OS recommendations for large databases ( David Lang <dlang@invendra.net>
Re: Hardware/OS recommendations for large databases ( Brendan Duddridge <brendan@clickspace.com>
Re: Hardware/OS recommendations for large databases ( David Boreham <david_list@boreham.org>
Re: Hardware/OS recommendations for large databases ( David Lang <dlang@invendra.net>
Mark,

On 11/28/05 1:45 PM, "Mark Kirkwood"  wrote:

>>> 8.0 : 32 s
>>> 8.1 : 25 s

A 22% reduction.

select count(1) on 12,900MB = 1617125 pages fully cached:

MPP based on 8.0 : 6.06s
MPP based on 8.1 : 4.45s

A 26% reduction.

I'll take it!

I am looking to back-port Tom's pre-8.2 changes and test again, maybe
tonight.

- Luke


В списке pgsql-performance по дате отправления
От: Mark Kirkwood
Дата:
От: David Gagnon
Дата:
FAQ