datetime extract function performance

Ying Zhang Y.Zhang at
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,


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

developers-list mailing list
developers-list at

More information about the developers-list mailing list