Hi:
I have a MonetDB 5 server v11.23.7 "Jun2016-SP1 instance hosting a
table with over 5600 columns (for the US General Social Survey)
If we run a simple query like
SELECT * FROM gss7214_v4 limit 2
we get the first two records as expected.
However, the same query with all the column names explicitly stated like
select
"year","id","wrkstat","hrs1","hrs2","evwork","occ","prestige","wrkslf",<...thousands
of additional columns - see attached...> from "gss7214_v4" WHERE
"year"=1972 LIMIT 2 OFFSET 0;
seem to kill the server. The process keeps running but become
non-responsive.
Now this is on a AWS EC2 t2.small instance with just ~2Gb or memory.
Maybe more memory may solve this issue (?). But in any case concerned
that the server hangs without warning or error message in the log. Any
potential workaround? Suggestion most appreciated
best
*P
