作者小头像 Lv.1
0 成长值

个人介绍

这个人很懒,什么都没有留下

感兴趣或擅长的领域

暂无数据
个人勋章
TA还没获得勋章~
成长雷达
0
0
0
0
0

个人资料

个人介绍

这个人很懒,什么都没有留下

感兴趣或擅长的领域

暂无数据

达成规则

他的回复:
可以了,改了一些配置,不懂是哪个生效了,正常了。- 工作内存(影响排序、哈希操作)ALTER DATABASE et_os SET work_mem = '12MB';-- 维护工作内存(影响VACUUM、索引创建)ALTER DATABASE et_os SET maintenance_work_mem = '50MB';ALTER DATABASE et_os SET bulk_write_ring_size = '8388608';-- 共享缓冲区ALTER  SYSTEM  SET shared_buffers = '256MB';-- 执行这些最相关的参数调整ALTER SYSTEM SET walsender_max_send_size = '65536';ALTER SYSTEM SET wal_receiver_buffer_size = '262144';ALTER SYSTEM SET data_replicate_buffer_size = '65536';ALTER SYSTEM SET shared_buffers = '524288';ALTER SYSTEM SET wal_buffers = '16384';-- 1. 增加WAL发送器最大发送大小(当前8192=8KB太小)ALTER SYSTEM SET walsender_max_send_size = '65536';  -- 增加到64KB-- 2. 增加WAL接收器缓冲区大小(当前65536=64KB)ALTER SYSTEM SET wal_receiver_buffer_size = '262144'; -- 增加到256KB-- 3. 增加数据复制缓冲区(当前16384=16KB)ALTER SYSTEM SET data_replicate_buffer_size = '65536'; -- 增加到64KB-- 4. 增加共享缓冲区(当前131072=128MB)ALTER SYSTEM SET shared_buffers = '524288'; -- 增加到512MB -- 重载配置SELECT pg_reload_conf()-- 重载配置SELECT pg_reload_conf();-- 查看所有与内存、数据包相关的参数SELECT name, setting, unit, short_descFROM pg_settings WHERE name LIKE '%size%'    OR name LIKE '%mem%'   OR name LIKE '%buffer%'   OR name LIKE '%packet%'   OR name LIKE '%io%'   OR name LIKE '%work%'ORDER BY name;
他的回复:
表结构: CREATE TABLE flow_instance (     id bigint NOT NULL,     definition_id bigint NOT NULL,     business_id character varying(40) NOT NULL,     node_type smallint NOT NULL,     node_code character varying(40) NOT NULL,     node_name character varying(100),     variable text,     flow_status character varying(20) NOT NULL,     activity_status smallint DEFAULT 1 NOT NULL,     create_time timestamp without time zone,     create_by character varying(64) DEFAULT NULL::character varying,     update_time timestamp without time zone,     update_by character varying(64) DEFAULT NULL::character varying,     ext character varying(500),     del_flag character(1) DEFAULT '0'::character varying,     tenant_id character varying(40),     def_json text ) WITH (orientation=row, compression=no); COMMENT ON TABLE flow_instance IS '流程实例表'; COMMENT ON COLUMN flow_instance.id IS '主键id'; COMMENT ON COLUMN flow_instance.definition_id IS '对应flow_definition表的id'; COMMENT ON COLUMN flow_instance.business_id IS '业务id'; COMMENT ON COLUMN flow_instance.node_type IS '节点类型(0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关)'; COMMENT ON COLUMN flow_instance.node_code IS '流程节点编码'; COMMENT ON COLUMN flow_instance.node_name IS '流程节点名称'; COMMENT ON COLUMN flow_instance.variable IS '任务变量'; COMMENT ON COLUMN flow_instance.flow_status IS '流程状态(0待提交 1审批中 2审批通过 4终止 5作废 6撤销 8已完成 9已退回 10失效 11拿回)'; COMMENT ON COLUMN flow_instance.activity_status IS '流程激活状态(0挂起 1激活)'; COMMENT ON COLUMN flow_instance.create_time IS '创建时间'; COMMENT ON COLUMN flow_instance.create_by IS '创建人'; COMMENT ON COLUMN flow_instance.update_time IS '更新时间'; COMMENT ON COLUMN flow_instance.update_by IS '更新人'; COMMENT ON COLUMN flow_instance.ext IS '扩展字段,预留给业务系统使用'; COMMENT ON COLUMN flow_instance.del_flag IS '删除标志'; COMMENT ON COLUMN flow_instance.tenant_id IS '租户id'; ALTER TABLE flow_instance ADD CONSTRAINT flow_instance_pkey PRIMARY KEY (id); 插入语句: INSERT INTO flow_instance (   ID,   business_id,   definition_id,   node_code,   node_name,   node_type,   flow_status,   activity_status,   def_json,   create_by,   create_time,   update_time,   del_flag,   update_by  ) VALUES   (     1441893304693297152,     '123',     1441084327969558528,     'submit',     '蓝票审核',     1,     '1',     1,     '{"flowCode":"leaveFlow-serial2","flowName":"测试","modelValue":"CLASSICS","category":"1","version":"1","isPublish":1,"formCustom":"N","formPath":"system/leave/approve.vue","nodeList":[{"nodeType":0,"nodeCode":"start","nodeName":"开始","nodeRatio":0.000,"coordinate":"260,200|260,200","ext":"[]","status":2,"skipList":[{"nowNodeCode":"start","nextNodeCode":"submit","skipType":"PASS","coordinate":"280,200;370,200","status":2,"createBy":"1","updateBy":"1"}],"createBy":"1","updateBy":"1"},{"nodeType":1,"nodeCode":"submit","nodeName":"蓝票审核","permissionFlag":"2","nodeRatio":0.000,"coordinate":"420,200|420,200","formCustom":"N","formPath":"system/leave/approve.vue","ext":"[{\\\"code\\\":\\\"base3\\\",\\\"value\\\":\\\"common\\\"},{\\\"code\\\":\\\"base4\\\",\\\"value\\\":\\\"1\\\"},{\\\"code\\\":\\\"new_tabs1\\\",\\\"value\\\":\\\"3,4\\\"},{\\\"code\\\":\\\"new_tabs2\\\",\\\"value\\\":\\\"1\\\"},{\\\"code\\\":\\\"base1\\\",\\\"value\\\":\\\"测试\\\"},{\\\"code\\\":\\\"base2\\\",\\\"value\\\":\\\"测试\\\"}]","status":1,"skipList":[{"nowNodeCode":"submit","nextNodeCode":"end","skipType":"PASS","coordinate":"470,200;577,200","status":0,"createBy":"1","updateBy":"1"}],"createBy":"1","updateBy":"1"},{"nodeType":2,"nodeCode":"end","nodeName":"结束","nodeRatio":0.000,"coordinate":"597,200|597,200","ext":"[]","status":0,"createBy":"1","updateBy":"1"}],"topTextShow":false,"createBy":"1","updateBy":"1"}',   '18775443985',   NOW( ),   NOW( ),   '0', '18775443985'  )