官术网_书友最值得收藏!

Chapter 2. Server Configuration and Control

In this chapter, we will cover the following:

  • Starting the database server manually
  • Stopping the server quickly
  • Stopping the server in an emergency
  • Reloading server configuration
  • Restarting the database server quickly
  • Tuning connection-related parameters
  • Tuning query-planning parameters
  • Tuning logging-related parameters

Introduction

This chapter basically deals with the server architecture and server control. Initially, we will discuss the different options available to start and stop the PostgreSQL server. As an administrator, one should be aware of the different methods available in order to use the appropriate option in emergency situations or during maintenance operations. We then move onto discussing different server parameters and the tuning aspects related to them. Some important server parameters that help improve the overall server throughput and performance are discussed here from an optimization perspective.

主站蜘蛛池模板: 阿克陶县| 西城区| 无为县| 新绛县| 建宁县| 沾化县| 蓬莱市| 讷河市| 乡宁县| 三都| 安西县| 泉州市| 湟源县| 周口市| 长葛市| 邢台县| 丁青县| 林芝县| 许昌市| 吉首市| 秦皇岛市| 台东市| 天台县| 台中县| 当涂县| 敦煌市| 马公市| 宜兴市| 堆龙德庆县| 大竹县| 永泰县| 墨竹工卡县| 嘉黎县| 鄄城县| 吴堡县| 和顺县| 弋阳县| 平昌县| 宣武区| 九龙城区| 崇仁县|