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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Gagnon | 2005-11-28 23:40:59 | Please help with this explain analyse... |
Previous Message | Luke Lonergan | 2005-11-28 22:05:15 | Re: Hardware/OS recommendations for large databases ( |