vecterwise的一些函数

〇〇 · 发表于 2012-10-18 19:29

〇〇 · 发表于 2012-10-18 19:29

还可以查看数据库信息
C:\Users\db2admin\pgsql\bin>"C:\Program Files\Actian\VectorwiseVW\ingres\bin\vwinfo" -s tpch
+--------------------------------+--------------------------------------------+
|stat                         |value                                     |
+--------------------------------+--------------------------------------------+
|memory.query_allocated       |41173664                                  |
|memory.query_maximum          |2147483648                               |
|memory.query_peak             |62177728                                  |
|memory.query_virtual_allocated  |45368944                                  |
|memory.query_virtual_maximum |4398046511104                            |
|memory.query_virtual_peak    |199781039216                               |
|memory.update_allocated       |2382                                     |
|memory.update_maximum          |536870912                                  |
|memory.committed_transactions |0                                        |
|memory.bufferpool_allocated    |0                                        |
|memory.bufferpool_maximum    |1070596096                               |
|bm.block_size                |524288                                     |
|bm.group_size                |8                                        |
|bm.columnspace_used_blocks    |10821                                     |
|bm.bufferpool_total_blocks    |2042                                     |
|bm.bufferpool_free_blocks    |2042                                     |
|bm.bufferpool_used_blocks    |0                                        |
|bm.bufferpool_cached_blocks    |0                                        |
|bm.columnspace_location       |C:\Program Files\Actian\VectorwiseVW\ingres\data\vectorwise\tpch\CBM\default\0|
|system.active_sessions       |2                                        |
|system.log_file_size          |2139574                                  |
|system.threshold_log_condense |33554432                                  |
|server.port_number             |7659                                     |
|server.pid                   |4404                                     |
+--------------------------------+--------------------------------------------+

〇〇 · 发表于 2012-10-18 19:30

〇〇 · 发表于 2012-10-18 19:34

cte还可以从先定义的虚表定义后一个虚表

* with t as(select * from emp),
* t1 as(select * from t where empno=1)
* select * from t,t1 where t.empno>t1.empno;
* \g
Executing . . .

+-------------+--------------------+-------------+--------------------+
|empno       |name             |empno       |name             |
+-------------+--------------------+-------------+--------------------+
|          1|wang             |          2|zhang             |
|          1|wang             |          3|Li                |
|          1|wang             |          4|sun                |
+-------------+--------------------+-------------+--------------------+
(3 rows)
continue

〇〇 · 发表于 2012-10-18 19:34

cte还可以从先定义的虚表定义后一个虚表

* with t as(select * from emp),
* t1 as(select * from t where empno=1)
* select * from t,t1 where t.empno>t1.empno;
* \g
Executing . . .

+-------------+--------------------+-------------+--------------------+
|empno       |name             |empno       |name             |
+-------------+--------------------+-------------+--------------------+
|          1|wang             |          2|zhang             |
|          1|wang             |          3|Li                |
|          1|wang             |          4|sun                |
+-------------+--------------------+-------------+--------------------+
(3 rows)
continue

vecterwise的一些函数

浏览过的版块