windows does not release RAM after operations

[ajdamico]

review whether this (RESOLVED FIXED) bug has re-appeared in mserver or only in monetdblite

https://www.monetdb.org/bugzilla/show_bug.cgi?id=3835

definitely still happening in monetdblite (absurd screenshot)

[ajdamico]

obvious ram-intensive processes are releasing memory as expected. might need to look closer at sisyphus after lodown has been added to get a useable reproducible example

# using latest working windows github MonetDBLite
# devtools::install_github("hannesmuehleisen/MonetDBLite",ref="fcb21f4c4223024922221d4ed1a8e78d647d8abe")


dbdir <- tempdir()
tf <- tempfile()

library(DBI)
library(MonetDBLite)

# # monetdblite
# con <- dbConnect(MonetDBLite() , dbdir )

# # mserver
# startscript <- monetdb.server.setup(dbdir,"C:/Program Files/MonetDB/MonetDB5", "mydb", 50001)
# pid <- monetdb.server.start(startscript)
# con <- dbConnect(MonetDB.R(), "monetdb://localhost:50001/mydb" , wait = TRUE )


# 320,0000 records
x <- mtcars[ rep( 1:32 , 10000 ) , ]

write.csv( x , tf , row.names = FALSE )
dbWriteTable( con , 'x' , tf )

for( i in 1:100 ) {

	print( paste( "creating new table" , i , Sys.time() ) )
	dbSendQuery( con , paste0( "CREATE TABLE x" , i , " AS SELECT * FROM x WITH DATA" ) )
	
}

# monetdb.server.stop(pid)
# unlink( dbdir , recursive = TRUE )

[hannes]

is this still an issue?