datetime extract function performance

Ying Zhang Y.Zhang at cwi.nl
Fri Oct 19 16:08:05 CEST 2012


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 at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/developers-list

_______________________________________________
developers-list mailing list
developers-list at monetdb.org
http://mail.monetdb.org/mailman/listinfo/developers-list



More information about the developers-list mailing list