PostgreSQL Administration and Performance Tuning
Daty i czas trwania
Vaadake koolituse toimumiskuupäevi! Kui Teid huvitava koolituse infot hetkel avaldatud ei ole, võtke palun meiega ühendust.
VAATA KUUPÄEVI >>
Lisaks on võimalik broneerida veel üks päev, mille jooksul tegeleme individuaalsete küsimustega.
Publiczność
See kursus on eriti sobilik andmebaaside administraatoritele (Linux / Windows / Solaris / Mac OS X) ja süsteemihalduritele. Käsitleme administreerimise ja jõudluse häälestamisega seotud teemasid.
Treść kursu
Päev 1
- The PostgreSQL project, support, community, release- and version management
- Overview architecture
- Installation, start and stop the server, connect to the client
- Client “psql”
- Indexing with B-Tree indexes
- EXPLAIN
- Transactions: Atomicity, Isolation, Locking
Päev 2
- Transactions: optimistic and pessimistic “locks”
- Multiversioning
- VACUUM
- Autovacuum
- Logical backup, data export and import (pg_dump)
- physical backup, Transaction log archiving
- Point-in-time Recovery
Päev 3
- Streaming Replication
- Synchrone Replication
- Hot Standby and conflict management
- Failover
- High Availability, concept of Patroni
- User management, authentification
- Remote access to the database
- Permissions
Päev 4
- Configuration parameters
- Logging
- Resource management
- Parameter tuning
- Security
- Upgrade
- Statistics and monitoring
- Statement tuning
- EXPLAIN (ANALYZE, BUFFERS)
- Extended Statistics
Võtke meiega ühendust, et registreeruda sellele kursusele >>
Muud kursused, mis võivad Teile huvi pakkuda
Me pakume neid teenuseid
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 Infrastructure
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.