PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using all available resources. PostgreSQL provides a system where you can tune your database according to your workload and machine specifications. In addition to PostgreSQL, we can also tune our Linux box so that the database load can work optimally.

In this webinar on High-Performance PostgreSQL, Tuning, and Optimization, we will learn how to tune PostgreSQL and we'll see the results of that tuning. We will also touch on tuning some Linux kernel parameters.

#PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using all available resources. PostgreSQL provides a system where you can tune your database according to your workload and machine specifications. In addition to PostgreSQL, we can also tune our Linux box so that the database load can work optimally. In this webinar on High-Performance PostgreSQL, Tuning, and Optimization, we will learn how to tune PostgreSQL and we'll see the results of that tuning. We will also touch on tuning some Linux kernel parameters.

(post is archived)

You are currently inside a comment thread.

Click here to see all the comments (3).

[–] [deleted] • 0 pt

Any mention of data structure optimisation, normalisation or proper design of keys and indices?

link

[–] • 1 pt

Hi, well, are different topics what are you asking.

For indexes, this course is so good and has a free certification. https://youtu.be/ktae6vhUkKE

For normalization, this article explains a bit.

https://www.percona.com/blog/2020/05/29/removing-postgresql-bottlenecks-caused-by-high-traffic/

parent
link

[–] [deleted] • 0 pt

I do see your point, but all the applied server optimisation in the world will merely delay the failure of a poorly designed data structure.

Source: learned to write SQL on mainframe

parent
link