PostgreSQL Configuration: Best Practices for Performance and Security (Paperback)

There are multiple ways you can install PostgreSQL on a server. This chapter will talk about the best ways to do so, focusing on system-level parameter settings before installation as a prerequisite and also post-installation steps to avoid issues in the future.

PostgreSQL ships with a basic configuration tuned for wide compatibility rather than performance. Although the default settings of PostgreSQL are viable, it is always recommended to tune some basic parameters based on your environment and application behavior. 

Logging is key when you troubleshoot issues of PostgreSQL for security and performance to find out the trends. Default PostgreSQL configuration comes with very minimal logging and it is not always enough to troubleshoot the issues. So, this chapter will explain how to set logging and consequences of high logging and how to deal with it.

 

Good monitoring is a symbol of a peaceful life for an administrator. If you set up monitoring of your databases to alert you whenever an issue comes up, then you need not worry about keeping an eye at your databases' health. This chapter will show you ways to monitor PostgreSQL instances.

 

Why do you need maintenance? What would you get from it? when do decide "it's time for maintenance"? How do you do it? Is there any way I can improve my maintenance time? This chapter will shed some light on all these questions. 

 

Security is one of the major concerns for storing sensitive data. It could be one of the reasons customers change their database engines. So, this chapter will talk about how best you can secure your data in PostgreSQL.

 

For critical data systems, backup and restore is a very important consideration. However, it's very important to know what factors you should consider before you implement a backup strategy and how to implement one. This chapter talks about developing backup procedures for critical/non-critical data systems and quick restore procedures as well.

 

You may come across some situations where you cannot make your primary working with-in your affordable time window. What do you do in that scenario? Implementing High Availability is always the best practice for such critical applications. This chapter talks about HA implementation and open source tools that can be used with PostgreSQL to implement the same.

 

While running your application with limited resources, then it is highly recommended to use Pooling to connect the database. Performance of a database depends on the parallel connections that it can allow. Huge connections to a database in parallel degrades the database performance. This chapter will teach you to implement a pooler mechanism for your PostgreSQL instances.

 

Working with PostgreSQL, there are bound to be some errors you might face that takes a lot of time to resolve. And, some times you might need some queries which are based on catalogs to fetch the information. This chapter talks about some of these errors and their resolution so that it can save some time for administrators followed by handy queries to help them perform their daily duties.

Baji Shaik (지은이)    정보 더보기

분야의 베스트셀러 >