- PostgreSQL 9.0 High Performance
- Gregory Smith
- 279字
- 2021-04-13 16:58:48
There aren't a lot of easy answers for what filesystem to use or how to arrange your disks. It's better to err on the side of paranoia, not performance, if you expect to keep your database intact under the sort of odd things that will happen to it in production. And unfortunately, maximum reliability is usually slower too. The most valuable thing you can do is be systematic in how you test. Instrument what you're doing, benchmark whenever possible, and always try to collect reproducible examples of realistic workloads whenever they appear.
- Filesystem crash protection is mostly commonly done by journaling writes, which adds overhead but makes recovery time after unclean shutdown predictable.
- On Linux, the ext3 filesystem allows a wide variety of tuning possibilities for its journal. While not the best performer, its occasional problem spots are at least well understood. Both XFS and ext4 are at early production quality right now, and expected to become increasingly viable alternatives to ext3 in the near future.
- Solaris and FreeBSD both have older UFS filesystems and the newer ZFS available. ZFS has several features that make it uniquely suited for large database installations.
- The NTFS filesystem on Windows shares many fundamentals with the UNIX-based ones popular on other operating systems.
- Increasing read-ahead, stopping updates to file access timestamps, and adjusting the amount of memory used for caching are common tuning techniques needed to get good performance on most operating systems.
- PostgreSQL allows relocating parts of the database through both symbolic links and creation of tablespaces.
- The optimal way to arrange the components of a database across many available disks is very dependent on the specific application and usage pattern.
推薦閱讀
- JasperReports for Java Developers
- Oracle SOA Suite Developer's Guide
- 零基礎學數碼攝影后期
- Quickstart Apache Axis2
- Premiere視頻編輯應用教程:PremierePro 2020(微課版)
- 新媒體美工一冊通(全彩)
- PowerPoint 2016實戰從入門到精通(超值版)
- Indesign平面排版技術應用
- IBM WebSphere eXtreme Scale 6
- Mastering Zabbix
- 巧用ChatGPT高效搞定Excel數據分析
- 中文版Maya 2016基礎培訓教程
- Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
- Maya腳本應用手冊:表達式與MEL語言
- Photoshop移動UI設計