CN104809152B - 一种节约PostgreSQL共享内存的方法及系统 - Google Patents
一种节约PostgreSQL共享内存的方法及系统 Download PDFInfo
- Publication number
- CN104809152B CN104809152B CN201510107904.9A CN201510107904A CN104809152B CN 104809152 B CN104809152 B CN 104809152B CN 201510107904 A CN201510107904 A CN 201510107904A CN 104809152 B CN104809152 B CN 104809152B
- Authority
- CN
- China
- Prior art keywords
- postgresql
- major key
- recombination
- updated
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 19
- 238000005215 recombination Methods 0.000 claims abstract description 22
- 230000006798 recombination Effects 0.000 claims abstract description 22
- 101000911390 Homo sapiens Coagulation factor VIII Proteins 0.000 claims description 8
- 102000057593 human F8 Human genes 0.000 claims description 8
- 229940047431 recombinate Drugs 0.000 claims description 8
- 238000009826 distribution Methods 0.000 claims description 7
- 238000012216 screening Methods 0.000 claims description 5
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 238000003860 storage Methods 0.000 abstract description 4
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000004048 modification Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (5)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510107904.9A CN104809152B (zh) | 2015-03-12 | 2015-03-12 | 一种节约PostgreSQL共享内存的方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510107904.9A CN104809152B (zh) | 2015-03-12 | 2015-03-12 | 一种节约PostgreSQL共享内存的方法及系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104809152A CN104809152A (zh) | 2015-07-29 |
CN104809152B true CN104809152B (zh) | 2018-08-17 |
Family
ID=53693975
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510107904.9A Active CN104809152B (zh) | 2015-03-12 | 2015-03-12 | 一种节约PostgreSQL共享内存的方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104809152B (zh) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105573678B (zh) * | 2015-12-17 | 2018-11-09 | 深圳市华讯方舟软件技术有限公司 | 一种PostgreSQL块 |
CN110866063B (zh) * | 2018-08-27 | 2023-10-31 | 阿里云计算有限公司 | 一种数据跟踪处理方法及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8280907B2 (en) * | 2005-11-30 | 2012-10-02 | International Business Machines Corporation | System and method for managing access to data in a database |
CN103403707A (zh) * | 2010-12-28 | 2013-11-20 | 思杰系统有限公司 | 用于数据库代理请求交换的系统和方法 |
CN103593440A (zh) * | 2013-11-15 | 2014-02-19 | 北京国双科技有限公司 | 日志文件的读写方法及装置 |
CN104216986A (zh) * | 2014-09-03 | 2014-12-17 | 陈飞 | 以数据更新周期进行预操作提高数据查询效率的装置及方法 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20090319721A1 (en) * | 2008-06-19 | 2009-12-24 | Silicon Motion, Inc. | Flash memory apparatus and method for operating the same |
-
2015
- 2015-03-12 CN CN201510107904.9A patent/CN104809152B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8280907B2 (en) * | 2005-11-30 | 2012-10-02 | International Business Machines Corporation | System and method for managing access to data in a database |
CN103403707A (zh) * | 2010-12-28 | 2013-11-20 | 思杰系统有限公司 | 用于数据库代理请求交换的系统和方法 |
CN103593440A (zh) * | 2013-11-15 | 2014-02-19 | 北京国双科技有限公司 | 日志文件的读写方法及装置 |
CN104216986A (zh) * | 2014-09-03 | 2014-12-17 | 陈飞 | 以数据更新周期进行预操作提高数据查询效率的装置及方法 |
Also Published As
Publication number | Publication date |
---|---|
CN104809152A (zh) | 2015-07-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102741843B (zh) | 从数据库中读取数据的方法及装置 | |
CN106294772B (zh) | 分布式内存列式数据库的缓存管理方法 | |
CN102129442B (zh) | 一种分布式数据库系统和数据访问方法 | |
US7797347B2 (en) | Workload aware checking of database reorganization | |
CN110597859B (zh) | 一种分页查询数据的方法和装置 | |
CN105930387A (zh) | 一种基于数据路由、分库分表的数据操作系统及方法 | |
CN102043859A (zh) | 数据更新方法及装置 | |
CN107423404B (zh) | 流程实例数据同步处理方法和装置 | |
CN102270225A (zh) | 数据变更日志监控方法和数据变更日志监控装置 | |
CN104423960A (zh) | 一种项目持续集成的方法及系统 | |
CN109271435A (zh) | 一种支持断点续传的数据抽取方法及系统 | |
CN103886005A (zh) | 用于为增强查询性能使用临时性能对象的方法和系统 | |
CN105159845A (zh) | 存储器读取方法 | |
CN107704573A (zh) | 一种与业务耦合的智能缓存方法 | |
CN103020149A (zh) | 共享数据更新装置和共享数据更新方法 | |
CN109885642B (zh) | 面向全文检索的分级存储方法及装置 | |
CN102467525A (zh) | 单据关联方法及系统 | |
CN103593460A (zh) | 数据分级存储系统和数据分级存储方法 | |
CN105631019A (zh) | 元数据扩展方法和元数据扩展装置 | |
CN104809152B (zh) | 一种节约PostgreSQL共享内存的方法及系统 | |
CN104598652B (zh) | 一种数据库查询方法及装置 | |
CN102982186A (zh) | 基于oracle数据库系统的range分区表的维护方法和系统 | |
CN104391745A (zh) | 一种可扩展的对象生命周期管理方法 | |
CN105320676A (zh) | 一种客户数据查询服务方法及装置 | |
CN103778064B (zh) | 一种数据管理方法及装置 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
EXSB | Decision made by sipo to initiate substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP03 | Change of name, title or address | ||
CP03 | Change of name, title or address |
Address after: 310000 room 1001, building 2, No. 2, ZIJINGHUA Road, Xihu District, Hangzhou City, Zhejiang Province Patentee after: HANGZHOU MEGA TECHNOLOGY Co.,Ltd. Address before: 10, building 2, block B, The Union Buildings, No. 310013, Bauhinia Road, Hangzhou, Xihu District, Zhejiang Patentee before: Hangzhou Mijia Technology Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder |
Address after: 310000 room 1001, building 2, No. 2, ZIJINGHUA Road, Xihu District, Hangzhou City, Zhejiang Province Patentee after: Hangzhou Sikai Data Technology Group Co.,Ltd. Address before: 310000 room 1001, building 2, No. 2, ZIJINGHUA Road, Xihu District, Hangzhou City, Zhejiang Province Patentee before: HANGZHOU MEGA TECHNOLOGY Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210416 Address after: No. 181, erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee after: Chen Ximei Address before: 310000 room 1001, building 2, No. 2, ZIJINGHUA Road, Xihu District, Hangzhou City, Zhejiang Province Patentee before: Hangzhou Sikai Data Technology Group Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210608 Address after: 201100 room 509, building 2, No. 508, Chundong Road, Minhang District, Shanghai Patentee after: SHANGHAI TAIYU INFORMATION TECHNOLOGY Co.,Ltd. Address before: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee before: Chen Ximei |
|
TR01 | Transfer of patent right |