列存储数据库MonetDB的安装配置

〇〇

# MonetDB server v5.22.1, based on kernel v1.40.1
# Release Oct2010
# Serving database 'demo', using 48 threads
# Compiled for i686-pc-win32/64bit with 32bit OIDs dynamically linked
# Found 31.990 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
#warning: please don't forget to set your vault key!
#(see F:\MonetDB5\etc\monetdb5.conf)
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/SQL module v2.40.1 loaded
># SQL catalog created, loading sql scripts once

〇〇

数据量更大些，monetdb的性能就下降了，不如InfiniDB
sql>CREATE TABLE REN41
more>  (  R0 VARCHAR(1),
more>      ID VARCHAR(18),
more>      R01 VARCHAR(2),
more>      R02 VARCHAR(1),
more>      R03 VARCHAR(1),
more>      R041 VARCHAR(4),
more>      R042 VARCHAR(2),
more>      R05 VARCHAR(2),
more>      R061 VARCHAR(1),
more>      R062 VARCHAR(1),
more>      R063 VARCHAR(2),
more>      R07 VARCHAR(1),
more>      R081 VARCHAR(1),
more>      R082 VARCHAR(2),
more>      R09 VARCHAR(1),
more>      R101 VARCHAR(1),
more>      R102 VARCHAR(2),
more>      R103 VARCHAR(2),
more>      R104 VARCHAR(2),
more>      R11 VARCHAR(1),
more>      R12 VARCHAR(1),
more>      R131 VARCHAR(1),
more>      R132 VARCHAR(2),
more>      R14 VARCHAR(1),
more>      R151 VARCHAR(1),
more>      R152 VARCHAR(1),
more>      R16 VARCHAR(1),
more>      R17 VARCHAR(1),
more>      R18 VARCHAR(1),
more>      R19 VARCHAR(3),
more>      R20 VARCHAR(3),
more>      R211 VARCHAR(1),
more>      R212 VARCHAR(3),
more>      R22 VARCHAR(1),
more>      R23 VARCHAR(1),
more>      R241 VARCHAR(4),
more>      R242 VARCHAR(2),
more>      R251 VARCHAR(1),
more>      R252 VARCHAR(1),
more>      R253 VARCHAR(1),
more>      R254 VARCHAR(1),
more>      R261 VARCHAR(1),
more>      R262 VARCHAR(2),
more>      R263 VARCHAR(1),
more>      R264 VARCHAR(2),
more>      R265 VARCHAR(1),
more>      RA0 VARCHAR(1),
more>      RA1 VARCHAR(3),
more>      RA2 VARCHAR(1),
more>      RA20 VARCHAR(2),
more>      RA21 VARCHAR(2),
more>      RA22 VARCHAR(2)
more>);
operation successful
Timer      23.410 msec 1 rows
sql>COPY INTO ren41 FROM 'F:/soft/ren41.csv' DELIMITERS ',' ;
91236854 affected rows (25m 38s)
Timer 1538297.851 msec 1 rows
sql>select count(*) from ren41;
+----------+
| L216     |
+==========+
| 91236854 |
+----------+
1 tuple (131.640ms)
Timer     150.343 msec 1 rows
sql>select r03, r05,count(*)as cnt from ren41 where length(r05)=1 and r05<'3' group by r03,r05;
+------+------+------+
| r03  | r05  | cnt  |
+======+======+======+
| 2    | 1    |  729 |
| 1    | 1    |  716 |
| 1    | 2    |    2 |
| 2    | 2    |    2 |
+------+------+------+
4 tuples (48.3s)
Timer   48424.630 msec 4 rows
sql>

〇〇

增加2条件，又慢了很多
sql>select r03, r05,count(*) as cnt
more>from ren41 where (length(r05)=1 and r05<'3' ) or (length(r05)=2 and r05<'03' )
more>group by r03,r05;
+------+------+----------+
| r03  | r05  | cnt      |
+======+======+==========+
| 2    | 1    |      729 |
| 1    | 1    |      716 |
| 1    | 01   | 46468260 |
| 2    | 01   | 43623581 |
| 1    | 02   |    44435 |
| 2    | 02   |    37731 |
| 1    | 2    |        2 |
| 2    | 2    |        2 |
+------+------+----------+
8 tuples (2m 26s)
Timer  146620.791 msec 8 rows

kerrycode

正需要这方面的资料！谢谢

postgresql_user

这个数据库稳定性不是很好，用着用着突然crash掉，不知道楼主是否出现过类似问题，查询性能确实非常优异！