- 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.
推薦閱讀
- AutoCAD 2020中文版從入門到精通(標(biāo)準(zhǔn)版)
- Adobe 創(chuàng)意大學(xué)動(dòng)漫設(shè)計(jì)師Flash CS5 + Photoshop CS5 標(biāo)準(zhǔn)實(shí)訓(xùn)教材
- Adobe Illustrator 2023基礎(chǔ)教材
- 跟儲(chǔ)君老師學(xué)Excel極簡思維
- Windows Phone 7 Silverlight Cookbook
- 3ds Max 2015中文版從入門到精通
- BlackBerry Enterprise Server 5 Implementation Guide
- AutoCAD 2024建筑設(shè)計(jì)從入門到精通(升級(jí)版)
- 說服力:工作型PPT該這樣做(第2版)
- IBM WebSphere eXtreme Scale 6
- 虛擬現(xiàn)實(shí):沉浸于VR夢境
- AutoCAD 2016中文版基礎(chǔ)教程(全圖解視頻版)
- Joomla! 1.5 JavaScript jQuery
- Joomla! 1.5 Top Extensions Cookbook
- Photoshop CC平面設(shè)計(jì)實(shí)戰(zhàn)從入門到精通