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
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