datetime extract function performance
Y.Zhang at cwi.nl
Fri Oct 19 16:08:05 CEST 2012
Before we can say anything about your use case, would you please provide
us the following information:
- db schema
- db size
- output of 'mserver5 --version'
- 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?
On Fri, Oct 19, 2012 at 02:34:02AM -0700, metin d wrote:
> 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 ?
> developers-list mailing list
> developers-list at monetdb.org
developers-list mailing list
developers-list at monetdb.org
More information about the developers-list