Re: Performance comparison between Postgres and Greenplum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Hi Alex,

Yes, I have got 2 segments and a master host. So, in a way processing should be faster in Greenplum.

Actually this is only a sort of Proof of Concept trial that I am carrying out to notice differences between greenplum and postgres, if any.

For other queries though, results are satisfactory or at least comparable, like-

select distinct so_no, serial_no from observation_all;
in postgres it takes - 1404.238 ms
in gp it takes - 1217.283 ms


Regards,

Suvankar Roy


Alex Goncharov <alex-goncharov@xxxxxxxxxxx>

07/15/2009 06:07 PM

Please respond to
Alex Goncharov <alex-goncharov@xxxxxxxxxxx>

To
Suvankar Roy <suvankar.roy@xxxxxxx>
cc
pgsql-performance@xxxxxxxxxxxxxx
Subject
Re: Performance comparison between Postgres and Greenplum





,--- You/Suvankar (Mon, 13 Jul 2009 16:53:41 +0530) ----*
| 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.

Why do you believe so?

Is your data distributed and served by separate segment hosts?  By how
many?  Is the network connectivity not a factor?  What happens with
the times if you don't sort your result set?

-- Alex -- alex-goncharov@xxxxxxxxxxx --


ForwardSourceID:NT00004AF2    
=====-----=====-----=====
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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux