Hello Stefan,

Thanks for your valuable suggestions. I will do the same as you have instructed.

I have one more question regarding the same issue. I am also implementing the same on Postgres (Row-store database)

and I also have the same problem with that.  Please let me know if you know any tool which flushes the cache in postgres.

Thanks in advance.

Prashant

On Wed, Sep 10, 2014 at 6:10 PM, Stefan Manegold <Stefan.Manegold@cwi.nl> wrote:

Hi Prashant,

MonetDB does not cache query results, definitely not across client sessions,
let alone across server restarts.

You operatings systems file system might do caching, though.
Please refer to you file system and/or OS documentation for
information on how to flush/empty these caches.

Best,
Stefan

----- Original Message -----
>
>
>
> Dear all,
>
> as a part of my project, i have to check the performance of monetdb
> column-store database. I am very new to this technology, so i dont know
> where the monetdb caches its previous query results..
>
> I want to know how can i take results for cold runs on monetdb ( i have tried
> closing monetdb client and server every time i fire a query , but doesnt
> seem to clear the cache and i always get hot runs result)
>
> so please can anyone help me regarding these....
> suggestions are appreciated..
>
>
> thanks in advance..
>
> Prashant Rajkotiya
> M.tech. (ICT)
> DA-IICT ,Gandhinagar
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

--
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list