PostgreSQL Administration and Performance Tuning
Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This course takes 3 days with 8 hours each (on site) or 5 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis. We will deal with administration and performance tuning related topics.
This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.
- The PostgreSQL projekt, support, community, release management
- Architecture – overview
- Installation, starting and stopping the server, connection to the client
- Basics about “psql”
- Indexing with B-Tree indexes
- Transactions: Atomicity, Isolation, Locking
- Transactions: optimistic vs pessimistic locking
- Logical Backup, data export and import (pg_dump)
- Physical Backup, Transaction log archiving
- Point-in-time Recovery
- Configuration parameter
- Resource m anagement
- Parameter tuning
- User management, authentification
- Remote access
- Role management
- Statistics and monitoring
Contact us to sign up for this course >>
Other courses that might interest you
GIS ESSENTIALS – „GETTING SPATIALLY ENABLED“
PostgreSQL High Availability & Patroni Cluster Manager
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
Introduction to PostGIS
Introduction to PostgreSQL
PostgreSQL for business intelligence and big data analysis
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.