- PostgreSQL 9.0 High Performance
- Gregory Smith
- 274字
- 2021-04-13 16:58:44
While every application has unique growth aspects, there are many common techniques that you'll find necessary as an application using a PostgreSQL database becomes used more heavily. The chapters of this book each focus on one of the common aspects of this process. The general path that database servers follow includes:
- Select hardware to run the server on. Ideally, you'll test that hardware to make sure it performs as expected too.
- Set up all the parts of database disk layout: RAID level, filesystem, and possibly table/index layout on disk.
- Optimize the server configuration.
- Monitor server performance and how well queries are executing.
- Improve queries to execute more efficiently, or add indexes to help accelerate them.
- As it gets more difficult to just tune the server to do more work, instead reduce the amount it has to worry about by introducing connection pooling and caching.
- Replicate the data onto multiple servers and distribute reads among them.
- Partition larger tables into sections. Eventually, really large ones may need to be split so that they're written to multiple servers simultaneously.
This process is by no means linear. You can expect to make multiple passes over optimizing the server parameters. It may be the case that you decide to buy newer hardware first, rather than launching into replication or partitioning work that requires application redesign work. Some designs might integrate caching into the design from the very beginning. The important thing is to be aware of the various options available and to collect enough data about what limits the system is reaching to decide which of the potential changes is most likely to help.
- 中文版Photoshop CS6完全使用手冊(超值版)
- 做好PPT就靠這幾招:圖解力+吸引力+說服力
- 從零開始:AutoCAD 2015中文版機(jī)械制圖基礎(chǔ)培訓(xùn)教程
- Software Testing using Visual Studio 2010
- 圖解Word 2007圖文排版與辦公應(yīng)用
- Liferay User Interface Development
- Drools JBoss Rules 5.0 Developer's Guide
- 三維建模與3D打印從入門到精通
- AutoCAD 2020中文版入門、精通與實(shí)戰(zhàn)
- Photoshop CC 2019 平面設(shè)計(jì)實(shí)例教程
- Microsoft SharePoint 2010 and Windows PowerShell 2.0: Expert Cookbook
- Scribus 1.3.5: Beginner's Guide
- Microsoft SQL Server 2008 High Availability
- 中文版Photoshop CC 2018基礎(chǔ)培訓(xùn)教程(全彩版)
- 攝影師的后期課:Lightroom后期技法篇