Re: Performance comparison between Postgres and Greenplum - Mailing list pgsql-performance

From Suvankar Roy
Subject Re: Performance comparison between Postgres and Greenplum
Date
Msg-id OF98B28EF5.74EAD5B9-ON652575F4.00344843-652575F4.0034BAA6@tcs.com
Whole thread Raw
In response to Re: Performance comparison between Postgres and Greenplum  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance

Hi Scott,

Thanks for your input Scott.

But, then being a Massively Parallel Processing Database, is Greenplum not expected to outperform versions of Postgres higher than on which it is based.

My notion was that GP 3.3 (based on PostgreSQL 8.2.13) would exceed PG 8.3.7.

It seems that I was wrong here.

Regards,

Suvankar Roy



Scott Marlowe <scott.marlowe@gmail.com>

07/15/2009 03:00 PM

To
Suvankar Roy <suvankar.roy@tcs.com>
cc
pgsql-performance@postgresql.org
Subject
Re: [PERFORM] Performance comparison between Postgres and Greenplum





On Tue, Jul 14, 2009 at 11:33 PM, Suvankar Roy<suvankar.roy@tcs.com> wrote:
>
> Hi Scott,
>
> This is what I have got -
> In Greenplum, version PostgreSQL 8.2.13 (Greenplum Database 3.3.0.1 build 4) on
> i686-pc-linux-gnu, compiled by GCC gcc (GCC)

> In Postgres, version PostgreSQL 8.3.7, compiled by Visual C++ build 1400
> (1 row)

I wouldn't expect 8.2.x to outrun 8.3.x

ForwardSourceID:NT00004AD2    
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you


pgsql-performance by date:

Previous
From: Alex
Date:
Subject: Strange memory behavior with rails - caching in connection?
Next
From: "Lauris Ulmanis"
Date:
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance