PostgreSQL 9.6 Performance Story

아마존에 PostgreSQL 9.6 Performance Story를 출간했습니다.

“PostgreSQL 9.6 성능 이야기” 영문 버전을 아마존에 출간했습니다.

아마존에 영문판 DBMS 관련 서적을 출간한 것은 아마도 국내에서는 최초 내지는 다섯 손가락안에 들어갈 것 같습니다.  🙂

영문책표지.PNG

Paperback 에디션 바로가기

Kindle 에디션 바로가기

Chapter 2. Understanding Shared Buffer(PostgreSQL 9.6 Performance Story)

I am working on publishing the English version of “PostgreSQL 9.6 Performance Story” on Amazon. Below is a preview of Chapter 2.

Shared buffer is an essential component for efficient IO processing.

Because of this importance, the DBMS buffer manager will be highly optimized. In other words, if you set the Shared Buffer to a reasonable size (several Gb or tens of Gb, or even hundreds of Gb), there may not be a performance problem caused by Shared Buffer.

Then why? Do I need to know how Shared Buffer works? It is doubtful.

This is also the question I had when I started the Shared Buffer study.

However, as the research on Shared Buffer was repeated, it was found that Shared Buffer has  characteristics. IO strategy, ring buffer, and clock sweep algorithm. Without knowing these characteristics accurately, it can be difficult to determine the cause of sudden slowing of IO processing.

So let’s get to the point.

(more…)

Chapter 1. Architecture Overview (PostgreSQL 9.6 Performance Story)

I am working on publishing the English version of “PostgreSQL 9.6 Performance Story” on Amazon. Below is a preview of Chapter 1.

This section will explain several characteristics of the PostgreSQL structure and PostgreSQL.

PostgreSQL architecture


The physical structure of PostgreSQL is very simple. Shared memory, and very few background processes and data files. (See Figure 1-1)

1-1

Figure 1-1. PostgreSQL structure

(more…)