How to handling large volumes of data on PostgreSQL?
来源:互联网 发布:淘宝c店怎么开 编辑:程序博客网 时间:2024/06/05 14:48
mailing list: pgsql-admin.postgresql.org
from: Johann Spies
..loaded about 4,900,000,000 in one of two tables with 7200684 in the second table in database ‘firewall’, built one index using one date-field (which took a few days) and used that index to copy about 3,800,000,000 of those records from the first to a third table, deleted those copied record from the first table and dropped the third table.
This took about a week on a 2xCPU quadcore server with 8Gb RAM..—
Table paritioning is need.
distribute tables across different disks through tablespaces.Tweak the shared buffers and work_mem settings.
RAID5/6 are very,very slow when it comes to small disk *writes*.
At least a hardware RAID controller with RAID 0 or 10 should be used, with 10krpm or 15krpm drives. SAS preferred.
as on SATA the only quick disks are Western Digital Raptor.
look at a view called pg_stat_activity. Do: select * from pg_stat_activity;
- How to handling large volumes of data on PostgreSQL?
- How to delete a large number of data in SharePoint for List when refreshing data?
- How to sort an arbitrarily large set of data using Hadoop?
- How to remove GlusterFS Volumes
- How to display Computer,Home,Network,Trash and Mounted volumes icons on ubuntu 12.04 (Precise) deskt
- How To Find Large File Size On Linux
- How to open a large text file on Linux
- salesforce----------大数据处理与优化【Large Data Volumes】--上
- A Comparision of Approaches to Large-Scale Data Analysis(译)
- How to: Encrypt a Column of Data
- How to Configure and Run PostgreSQL on Solaris 10
- Designing Data Storage Architecture- How to Sync Large SQL Server Databases to SQL Azure
- How to get the data from a cell when I click on the GridButtonColumn of the same row
- How to disable flush of ASH data to AWR?
- How to load large files safely into InnoDB with LOAD DATA INFILE
- How to display the data from database on JTable
- How to install data-share area on VisualBox 4
- How to improve performance for predicate like '%search words%' on large tables?
- 一位软件工程师的6年总结
- 依米
- Process类的学习
- 你无法买到的高科技手机Top7
- 网站开发技术——细节研讨
- How to handling large volumes of data on PostgreSQL?
- 组织管理:打破玻璃 实现无距离沟通
- 使用PB编写不同应用之间的相互通讯
- TB级 PostgreSQL 拾零
- PostgreSQL 规模参考:400G+容量,N亿条记录
- 微软的经营之道
- 网络营销的六大特点和八大功能
- Creating an 8.2 warm-standby demo system
- 转帖:作java工程时的注意事项。