Performance comparison between Postgres and Greenplum

Hi,

I have some 99,000 records in a table (OBSERVATION_ALL) in a Postgres DB
as well as a Greenplum DB.

The Primary key is a composite one comprising of 2 columns (so_no,
serial_no).

The execution of the following query takes 8214.016 ms in Greenplum but
only 729.134 ms in Postgres.
select * from observation_all order by so_no, serial_no;

I believe that execution time in greenplum should be less compared to
postgres. Can anybody throw some light, it would be of great help.

Regards,

Suvankar Roy
=====-----=====-----=====
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