Re: Performance comparison between Postgres and Greenplum

Поиск
Список
Период
Сортировка
От Suvankar Roy
Тема Re: Performance comparison between Postgres and Greenplum
Дата
Msg-id OF1BC69A48.3BA89FC8-ON652575F4.0045498B-652575F4.00474CE3@tcs.com
обсуждение исходный текст
Ответ на Re: Performance comparison between Postgres and Greenplum  (Alex Goncharov <alex-goncharov@comcast.net>)
Ответы Re: Performance comparison between Postgres and Greenplum  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance

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@comcast.net>

07/15/2009 06:07 PM

Please respond to
Alex Goncharov <alex-goncharov@comcast.net>

To
Suvankar Roy <suvankar.roy@tcs.com>
cc
pgsql-performance@postgresql.org
Subject
Re: [PERFORM] 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@comcast.net --


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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Wayne Conrad
Дата:
Сообщение: Re: Poor overall performance unless regular VACUUM FULL
Следующее
От: toruvinn
Дата:
Сообщение: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance