发布于 2016-07-13 00:51:29 | 167 次阅读 | 评论: 0 | 来源: 网友投递
这里有新鲜出炉的PostgreSQL数据库教程,程序狗速度看过来!
PostgreSQL关系型数据库管理系统
PostgreSQL是以加州大学伯克利分校计算机系开发的 POSTGRES,现在已经更名为PostgreSQL,版本 4.2为基础的对象关系型数据库管理系统(ORDBMS)。
PostgreSQL 9.6 发布了,与9.5版本相比,新版本在配置文件中引入了新的参数 :
max_parallel_workers_per_gather: the number of workers that can assist a sequential scan of a table;
min_parallel_relation_size: the minimum size that a relation must have for the planner to consider the use of additional workers;
parallel_setup_cost: the planner parameter that estimates the cost of instantiate a worker;
parallel_tuple_cost: the planner parameter that estimates the cost of transferring a tuple from one worker to another;
force_parallel_mode: parameter useful for testing, strong parallelism and also a query in which the planner would operate in other ways.
详情:PostgreSQL 9.6: Parallel Sequential Scan