PostgreSQL Performance Tuning Training Course
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
Course Outline
- Introduction
- Query Tuning
- Logging in PostgreSQL
- Query Plans
- Statistics
- SQL Best Practices
- Indexes
- Table Partitioning
- Performance Tuning
- Operating System Best Practices
- Server Parameter Tuning
- Extension – pg_stat_statements
- Demo and Labs
- Benchmarking
- Database Benchmarking
- Pgbench
- Reading the Results
- Demo and Labs
Requirements
It is recommended to take this training only if you have a prior knowledge of PostgreSQL.
Open Training Courses require 5+ participants.
PostgreSQL Performance Tuning Training Course - Booking
PostgreSQL Performance Tuning Training Course - Enquiry
PostgreSQL Performance Tuning - Consultancy Enquiry
Consultancy Enquiry
Testimonials (5)
latihan praktis, demonstrasi dan kepercayaan diri dalam pengetahuan yang ditransfer.
Igor Werry - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
Machine Translated
Sulit untuk memilih satu hal, pelatihannya benar-benar bagus secara keseluruhan.
Darren Jones - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
Machine Translated
As I was the only participant I could influence the content and relative importance of subjects.
Andrew - WIM Ltd
Course - PostgreSQL Performance Tuning
Presenter memberi kami banyak ide baru untuk menyesuaikan PSQL kami untuk kinerja.
Adam Stafiej - Atlassian Poland sp. z o. o.
Course - PostgreSQL Performance Tuning
Machine Translated
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Upcoming Courses (Minimal 5 peserta)
Related Courses
Migrating Oracle to Azure SQL or PostgreSQL
7 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
- Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
- Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
- Perform post-migration steps to test, optimize, update, and maintain a migrated database.
PostgreSQL Administration and Development
28 HoursThis course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
PostgreSQL for Administrators - 2 Days
14 HoursThis course covers the administration and performance tuning of PostgreSQL databases.
Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
PostgreSQL Essentials
14 HoursPelatihan ini dirancang untuk Database Administrator dan Arsitek yang ingin belajar PostgreSQL dari dasar.
Anda akan mempelajari PostgreSQL arsitektur, instalasi, perancangan serta cara melakukan backup dan pemulihan database di PostgreSQL.
PostgreSQL Advanced DBA
14 HoursThis training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
Implementing High Availability in PostgreSQL
7 HoursThis training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.
PostgreSQL Administration, Optimization and Replication
35 HoursIn this instructor-led, live training in Indonesia (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
PostgreSQL for Developers
14 HoursThis course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
PostgreSQL 13 for Developers and Administrators
21 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications.
By the end of this training, participants will be able to:
- Install and configure PostgreSQL 13.
- Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
- Learn how to configure Postgres database tables and schemas.
- Learn how to perform data manipulations and queries.
- Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.
PostgreSQL 16 for Developers and Administrators
21 HoursPelatihan langsung yang dipimpin instruktur di Indonesia (online atau di lokasi) ditujukan untuk pengembang dan administrator tingkat menengah yang ingin memanfaatkan fitur dan peningkatan terbaru di PostgreSQL 16.
Pada akhir pelatihan ini, peserta akan mampu:
- Memahami arsitektur dan komponen PostgreSQL 16.
- Memanfaatkan fitur lanjutan SQL dan ekstensi PostgreSQL.
- Menerapkan praktik terbaik keamanan dan kontrol akses.
- Melakukan tugas administrasi basis data, termasuk pencadangan, pemulihan, dan pemantauan.
- Optimalkan kinerja database melalui strategi penyetelan dan pengindeksan.
- Manfaatkan alat bawaan PostgreSQL untuk ketersediaan dan replikasi tinggi.
- Integrasikan PostgreSQL dengan kerangka pengembangan aplikasi modern.
PostgreSQL for Administrators - 3 Days
21 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.
By the end of this training, participants will be able to:
- Install and configure PostgreSQL.
- Understand the features and architecture of PostgreSQL.
- Learn how to perform database operations with SQL.
- Perform database backup and recovery to prevent data loss.
- Configure the server for high availability.
- Learn the tools and techniques for high performance tuning.
- Explore the external tools for monitoring and observability.
PostgreSQL with Python
21 HoursPelatihan langsung yang dipimpin instruktur di Indonesia (online atau di lokasi) ditujukan untuk pengembang dan administrator yang ingin menggunakan PostgreSQL dengan Python untuk membangun aplikasi yang aman, andal, dan stabil dalam skala besar.
Pada akhir pelatihan ini, peserta akan mampu:
- Instal, konfigurasikan, dan sambungkan PostgreSQL dengan Python.
- Dapatkan penyegaran tentang Python dasar-dasar pemrograman.
- Pahami manfaat menggunakan PostgreSQL dengan Python.
- Pelajari cara melakukan operasi dasar SQL dengan Python.
- Pelajari cara menggunakan fitur lanjutan PostgreSQL dengan Python.
- Menerapkan teknik keselamatan, keamanan, pemantauan, dan pengoptimalan data.