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

Re: Hardware/OS recommendations for large databases (

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-28 23:19:34
Message-ID: 179B5137-F0BB-4037-A5AD-3459B914E580@clickspace.com (view raw or flat)
Thread:
Lists: pgsql-performance
Forgive my ignorance, but what is MPP? Is that part of Bizgres? Is it  
possible to upgrade from Postgres 8.1 to Bizgres?

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan(at)clickspace(dot)com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On Nov 28, 2005, at 3:05 PM, Luke Lonergan wrote:

> 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
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Responses

pgsql-performance by date

Next:From: David GagnonDate: 2005-11-28 23:40:59
Subject: Please help with this explain analyse...
Previous:From: Luke LonerganDate: 2005-11-28 22:05:15
Subject: Re: Hardware/OS recommendations for large databases (

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