Re: Hardware/OS recommendations for large databases (

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>, "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-28 22:05:15
Message-ID: BFB0BF1B.1495C%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mark,

On 11/28/05 1:45 PM, "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Brendan Duddridge 2005-11-28 23:19:34 Re: Hardware/OS recommendations for large databases (
Previous Message Mark Kirkwood 2005-11-28 21:45:46 Re: Hardware/OS recommendations for large databases (