CN104809152A - 一种节约PostgreSQL共享内存的方法及系统 - Google Patents
一种节约PostgreSQL共享内存的方法及系统 Download PDFInfo
- Publication number
- CN104809152A CN104809152A CN201510107904.9A CN201510107904A CN104809152A CN 104809152 A CN104809152 A CN 104809152A CN 201510107904 A CN201510107904 A CN 201510107904A CN 104809152 A CN104809152 A CN 104809152A
- Authority
- CN
- China
- Prior art keywords
- primary key
- restructuring
- postgresql
- saving
- shared drive
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 230000008569 process Effects 0.000 claims description 20
- 238000009826 distribution Methods 0.000 claims description 6
- 238000005215 recombination Methods 0.000 claims description 6
- 230000006798 recombination Effects 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 5
- 238000012217 deletion Methods 0.000 claims description 4
- 230000037430 deletion Effects 0.000 claims description 4
- 230000001143 conditioned effect Effects 0.000 claims description 3
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 239000002699 waste material Substances 0.000 abstract description 2
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 241000931705 Cicada Species 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 239000006185 dispersion Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
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 true CN104809152A (zh) | 2015-07-29 |
CN104809152B 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) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017101477A1 (zh) * | 2015-12-17 | 2017-06-22 | 深圳市华讯方舟软件技术有限公司 | 一种PostgreSQL块 |
CN110866063A (zh) * | 2018-08-27 | 2020-03-06 | 阿里巴巴集团控股有限公司 | 一种数据跟踪处理方法及装置 |
Citations (5)
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 |
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 | 陈飞 | 以数据更新周期进行预操作提高数据查询效率的装置及方法 |
-
2015
- 2015-03-12 CN CN201510107904.9A patent/CN104809152B/zh active Active
Patent Citations (5)
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 |
US20090319721A1 (en) * | 2008-06-19 | 2009-12-24 | Silicon Motion, Inc. | Flash memory apparatus and method for operating the same |
CN103403707A (zh) * | 2010-12-28 | 2013-11-20 | 思杰系统有限公司 | 用于数据库代理请求交换的系统和方法 |
CN103593440A (zh) * | 2013-11-15 | 2014-02-19 | 北京国双科技有限公司 | 日志文件的读写方法及装置 |
CN104216986A (zh) * | 2014-09-03 | 2014-12-17 | 陈飞 | 以数据更新周期进行预操作提高数据查询效率的装置及方法 |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017101477A1 (zh) * | 2015-12-17 | 2017-06-22 | 深圳市华讯方舟软件技术有限公司 | 一种PostgreSQL块 |
CN110866063A (zh) * | 2018-08-27 | 2020-03-06 | 阿里巴巴集团控股有限公司 | 一种数据跟踪处理方法及装置 |
CN110866063B (zh) * | 2018-08-27 | 2023-10-31 | 阿里云计算有限公司 | 一种数据跟踪处理方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
CN104809152B (zh) | 2018-08-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102741843B (zh) | 从数据库中读取数据的方法及装置 | |
CN103617131B (zh) | 一种实现数据缓存的方法 | |
US8799601B1 (en) | Techniques for managing deduplication based on recently written extents | |
CN104899156A (zh) | 一种面向大规模社交网络的图数据存储及查询方法 | |
CN105630865A (zh) | 用于内存列式存储的n比特压缩版本化列数据阵列 | |
US9632944B2 (en) | Enhanced transactional cache | |
EP3213230A1 (en) | Efficient maintenance of column store indexes on memory-optimized tables | |
US20130254240A1 (en) | Method of processing database, database processing apparatus, computer program product | |
TWI738037B (zh) | 分區分裂方法、裝置、電子設備及可讀儲存媒體 | |
US20190347337A1 (en) | Path name cache for notifications of file changes | |
CN104021145A (zh) | 一种混合业务并发访问的方法和装置 | |
KR20150053720A (ko) | 논리 블록 주소의 아토믹 스왑 및 트림을 위한 swat 커맨드 및 애플리케이션 프로그래밍 인터페이스 | |
CN104158897B (zh) | 一种分布式文件系统中文件布局的更新方法 | |
CN103106286A (zh) | 元数据的管理方法和装置 | |
CN110309233A (zh) | 数据存储的方法、装置、服务器和存储介质 | |
CN109885642B (zh) | 面向全文检索的分级存储方法及装置 | |
CN103902562A (zh) | 一种终端数据库升级方法及相关装置 | |
CN103678715A (zh) | 一种分布式文件系统中支持快照的元数据信息管理方法 | |
US11249968B2 (en) | Large object containers with size criteria for storing mid-sized large objects | |
CN103631972B (zh) | 一种列访问感知的数据缓存方法及系统 | |
CN105205178A (zh) | 一种多进程访问内存数据库系统 | |
CN102768672B (zh) | 一种磁盘空间管理方法和装置 | |
CN104809152A (zh) | 一种节约PostgreSQL共享内存的方法及系统 | |
CN104598652A (zh) | 一种数据库查询方法及装置 | |
CN102024051A (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 |