datetime extract function performance
Hey,
I'm running a small performance test on MonetDB and Postgres. According to my results "extract" function in monetDB (http://www.monetdb.org/Documentation/SQLreference/Temporal) is nearly 10x slower then Postgres.
Do you know the reason, or do you have any idea which can make "extract" function faster in MonetDB ?
Thanks, Metin
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
Hello Metin,
Before we can say anything about your use case, would you please provide us the following information:
- query - db schema - db size - output of 'mserver5 --version' - OS - Postgres version (assuming it's running on the same machine?) - execution time of your "extract" function on MonetDB and Postgres - how did you measure those times?
Kind regards,
Jennie
On Fri, Oct 19, 2012 at 02:34:02AM -0700, metin d wrote:
Hey,
I'm running a small performance test on MonetDB and Postgres. According to my results "extract" function in monetDB (http:/ /www.monetdb.org/Documentation/SQLreference/Temporal) is nearly 10x slower then Postgres.
Do you know the reason, or do you have any idea which can make "extract" function faster in MonetDB ?
Thanks, Metin
developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
Hi Ying,
Here the information yo asked. Best Regards, Metin
- queries and execution times (internel time reports of DBs) - there is only one day in the dataset I used time difference between queries with extract and without extract. For this examples, it is around 4x assuming difference is because of extract function.
MonetDB:
Ex. time: 4.8s SELECT extract(day from event_time) as event_day, act, count(*) FROM events GROUP BY act, event_day;
Ex. time: 70ms SELECT act, count(*) FROM events GROUP BY act;
Postgres:
Ex. time: 2.9s SELECT extract(day from event_time) as event_day, act, count(*) FROM events GROUP BY act, event_day;
Ex. time: 1.7s SELECT act, count(*) FROM events GROUP BY act;
-db schema
CREATE TABLE events( event_time timestamp, event varchar(100) );
- db size 300 MB
- output of 'mserver5 --version' MonetDB 5 server v11.11.11 "Jul2012-SP2" (64-bit, 64-bit oids)
- OS Ubuntu 12.04 LTS
- Postgres version 9.1.6
________________________________ From: Ying Zhang Y.Zhang@cwi.nl To: Communication channel for developers of the MonetDB suite. developers-list@monetdb.org Sent: Friday, October 19, 2012 5:08 PM Subject: Re: datetime extract function performance
Hello Metin,
Before we can say anything about your use case, would you please provide us the following information:
- query - db schema - db size - output of 'mserver5 --version' - OS - Postgres version (assuming it's running on the same machine?) - execution time of your "extract" function on MonetDB and Postgres - how did you measure those times?
Kind regards,
Jennie
On Fri, Oct 19, 2012 at 02:34:02AM -0700, metin d wrote:
Hey,
I'm running a small performance test on MonetDB and Postgres. According to my results "extract" function in monetDB (http:/ /www.monetdb.org/Documentation/SQLreference/Temporal) is nearly 10x slower then Postgres.
Do you know the reason, or do you have any idea which can make "extract" function faster in MonetDB ?
Thanks, Metin
developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
participants (2)
-
metin d
-
Ying Zhang