Re: [PERFORM] Hardware/OS recommendations for large databases (

[Brendan Duddridge]

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 |  [EMAIL PROTECTED]

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" <[EMAIL PROTECTED]> 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




TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------

smime.p7s
Description: S/MIME cryptographic signature