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

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.

主站蜘蛛池模板: 林口县| 汤原县| 赤城县| 环江| 嘉鱼县| 长治县| 含山县| 余江县| 大足县| 佛坪县| 丰台区| 苏州市| 芮城县| 黄大仙区| 丰城市| 佳木斯市| 福鼎市| 旌德县| 尉氏县| 武冈市| 恩施市| 仙游县| 斗六市| 荣昌县| 龙江县| 吉木萨尔县| 南郑县| 荥阳市| 当阳市| 靖宇县| 沙坪坝区| 花垣县| 台中县| 衡山县| 鄂州市| 西充县| 福海县| 原平市| 郓城县| 凤庆县| 晋中市|