- 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.
- AutoCAD 2022快速入門、進階與精通
- Protel DXP 2004 SP2原理圖與PCB設計(第4版)
- MLOps實戰:機器學習模型的開發、部署與應用
- Dreamweaver CC實例教程(第5版·微課版)
- 中文版Photoshop 2020基礎教程
- Adobe創意大學After Effects產品專家認證標準教材(CS6修訂版)
- 通達信炒股軟件從入門到精通(第2版)
- Unity 3D\2D手機游戲開發:從學習到產品(第4版)
- 邊做邊學:平面廣告設計與制作(Photoshop 2020+Illustrator 2020·第3版·微課版)
- PHP 5 Social Networking
- PostgreSQL Replication
- PPT設計與制作實戰教程
- Photoshop數字圖像處理
- AutoCAD 2024室內設計從入門到精通(升級版)
- Photoshop CG 古風插畫繪制技法精解