PostgreSQL - MC

PostgreSQL #3 - Architecture In the last post in the blog I installed PostgreSQL version 9.6.3. If you still didnt install postgresql on your machine I recommend you to do that. I think that hands on is the best way to understand a new technology. In order to understand how PostgreSQL really works it is importand to understand its architecture. When you will realize and understand its architecture it will be much easier to explain and understand many postgresql mechanisms. When you start PostgreSQL`s instance (via pg_ctl start) the main process of the databases is started. In the past versions it was known as the postmaster process and now days it is called postgres. When this processes is started it allocates memory for two main things : shared memory and other background processes. The shared memory is a memory that the database uses mainly for cashing. Its main goal is to reduce the I/O operations and as a result of that improve the performance of the database. The ...