developers-list September 2016

developers-list@monetdb.org

7 participants
3 discussions

by Hannes Mühleisen

Hello list, we were wondering about the purpose of GDK_mmap_minsize when creating transient columns. The attached patch will always *try* to malloc/realloc a transient column but still fall back to memory-mapped files if malloc should fail. This dramatically improves performance. Any good reason why this should not be the default behaviour? Thanks, Mark and Hannes

5 years, 10 months

eviction in Monetdb

by Narendra Pradeep

Hello , Need to know about monetdb eviction policy ? My understanding is Monetdb creates a buffer pool {BBP} and inserts all the bats that are used . But not sure when does Monetdb deletes the bat from the buffer pool and what eviction policy does it use (like LRU or based on some threshold) ? Thanks

5 years, 10 months

Re: MonetDB: graph1 - Add the operator bat.getCount() to retrieve th...

by Stefan Manegold

Hi Dean, how is bat.getCount() different from aggr.count() ? ;-) Thanks! Stefan ----- On Sep 14, 2016, at 6:30 PM, Dean De Leo commits+dleo=cwi.nl(a)monetdb.org wrote: > Changeset: 9ac831deacb3 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ac831deacb3 > Modified Files: > monetdb5/modules/kernel/bat5.c > monetdb5/modules/kernel/bat5.h > monetdb5/modules/kernel/bat5.mal > Branch: graph1 > Log Message: > > Add the operator bat.getCount() to retrieve the cardinality of a bat > > > diffs (48 lines): > > diff --git a/monetdb5/modules/kernel/bat5.c b/monetdb5/modules/kernel/bat5.c > --- a/monetdb5/modules/kernel/bat5.c > +++ b/monetdb5/modules/kernel/bat5.c > @@ -496,6 +496,19 @@ BKCgetColumnType(str *res, const bat *bi > } > > str > +BKCgetCount(lng *res, const bat *bid) > +{ > + *res = lng_nil; > + if (BBPcheck(*bid, "bat.getCount")) { > + BAT *b = BBPquickdesc(*bid, 0); > + > + if (b != NULL) > + *res = (lng) BATcount(b); > + } > + return MAL_SUCCEED; > +} > + > +str > BKCgetRole(str *res, const bat *bid) > { > BAT *b; > diff --git a/monetdb5/modules/kernel/bat5.h b/monetdb5/modules/kernel/bat5.h > --- a/monetdb5/modules/kernel/bat5.h > +++ b/monetdb5/modules/kernel/bat5.h > @@ -29,6 +29,7 @@ mal_export str BKCbun_inplace_force(bat > mal_export str BKCbat_inplace_force(bat *r, const bat *bid, const bat *rid, > const bat *uid, const bit *force); > mal_export str BKCgetCapacity(lng *res, const bat *bid); > mal_export str BKCgetColumnType(str *res, const bat *bid); > +mal_export str BKCgetCount(lng *res, const bat *bid); > mal_export str BKCgetRole(str *res, const bat *bid); > mal_export str BKCsetkey(bat *res, const bat *bid, const bit *param); > mal_export str BKCisSorted(bit *res, const bat *bid); > diff --git a/monetdb5/modules/kernel/bat5.mal b/monetdb5/modules/kernel/bat5.mal > --- a/monetdb5/modules/kernel/bat5.mal > +++ b/monetdb5/modules/kernel/bat5.mal > @@ -77,6 +77,10 @@ command getCapacity(b:bat[:any_1]):lng > address BKCgetCapacity > comment "Returns the current allocation size (in max number of elements) of a > BAT."; > > +command getCount(b:bat[:any_1]):lng > +address BKCgetCount > +comment "Returns the current tuple count of a BAT."; > + > command getColumnType( b:bat[:any_1] ) :str > address BKCgetColumnType > comment "Returns the type of the tail column of a BAT, as an integer type > number."; > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list -- | Stefan.Manegold(a)CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

5 years, 10 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

developers-list September 2016