Sjoerd Mullender

From the limited description, it sounds as if the server is thrashing. The issue might be that the server is using more memory than the system has (which causes thrashing)....

The algorithm is like this: do a select on the index column (there is an index column for the two column key--see the call to `sql.bind_idxbat`). Then to check whether...

There is no `extract(date from ...)`. You can only extract individual parts (year, month, day, hour, minute, second) and some larger ones (century, decade, quarter, week, dow (day-of-week), doy (day-of-year)).

I would suggest we add a link pointing to the manual, and in the manual elaborate if necessary. The manual is already a bit wordier than these one line descriptions....

Perhaps the first thing to try is to make sure there are no mserver5 processes running and then stopping and restarting monetdbd. Then try starting the database again. If that...

Do you have a large write-ahead log (WAL)? Try `du` on the `sql_logs` subdirectory of the database. My guess is, you do. And that is why startup takes long. Just...

To get a somewhat better error message from bison, we could add `%define parse.error detailed` to the sql_parser.y file (near `%define api.pure`). I have tried that in the past, but...

When you notice this again on a still running database, could you attach a debugger and call `BBPdump()` from the debugger? This function writes information about all known BATs to...

Automatic detection does happen, but only when it's deemed necessary for the algorithm being used. Keeping the sortedness information up-to-date comes at a cost, so it isn't done in all...

Also on the default branch since at some point that gets forked into a new stable branch.