- PostgreSQL 9.0 High Performance
- Gregory Smith
- 209字
- 2021-04-13 16:58:45
Building a database server with good performance is hard work. There are many individual components that are available in multiple quality levels and corresponding costs. Also there are plenty of small details you must get right or you'll risk data corruption. Luckily, you don't have to start from scratch. Stick to common, well understood components with known good performance, while keeping an eye on reliability too, and you can build a well balanced database server for a reasonable budget. Always make sure to run your own benchmarks on the result though. It's very easy to sabotage even good equipment with the wrong configuration when running a database.
- Allocating your hardware budget among CPUs, memory, and disks is very application dependent.
- Carefully selecting and configuring your controller and disk caches is critical for reliable database operation.
- Make sure you are monitoring components in your server that are likely to fail or have a known lifetime, particularly hard drives and the batteries in disk controller cards.
- Any disk write caches in your system must be confirmed to properly support the write flushing mechanism the database uses, or database corruption can result.
- The maximum rate that database clients can commit transactions can be very low without a properly implemented write-back cache.
推薦閱讀
- Creo Parametric 8.0中文版基礎(chǔ)入門一本通
- AutoCAD 2017實(shí)用教程
- IBM Lotus Notes 8.5 User Guide
- Moldflow模流分析與工程應(yīng)用
- Django 1.2 E/commerce
- UG NX 9.0中文版 基礎(chǔ)教程 (UG工程師成才之路)
- Photoshop CC從入門到精通（全彩超值版）
- PHP 5 Social Networking
- UG NX 9中文版從入門到精通
- 中文版Flash CS6動(dòng)畫制作（慕課版）
- SolidWorks 2020中文版從入門到精通
- Learning Dojo
- 中文版Maya 2016基礎(chǔ)培訓(xùn)教程
- Photoshop CG 古風(fēng)插畫繪制技法精解
- 攝影師的后期課：RAW格式技法篇