English
German
PostgreSQL for application administrators
PostgreSQL for application administrators
| Duration: | 2 Days |
| Level: | Intermediate |
| Preis: | contact us today |
| Audience: | Are you running a PostgreSQL driven application and to have to make sure that it is working 24×7? During this training you will learn how to achieve maximum availability for your application. You will also see how to improve performance and how to detect bottlenecks. |
Content:
Installing PostgreSQL
- Installing PostgreSQL on Windows
- Installing PostgreSQL on Linux
- Installing PostgreSQL addons
PostgreSQL fundamentals
- Creating a database instance
- Creating databases
PostgreSQL security
- PostgreSQL upgrades
- Defining user permissions
- Configuring network access
PostgreSQL performance tuning
- Using and understanding indexes
- Creating and deleting indexes
- Partial indexes
- Detecting useless indexes
- Using tablespaces
- Detecting slow queries
- Optimizing postgresql.conf
- Understanding VACUUM
Monitoring
- Understand log files
- Monitoring current queries
- Collecting performance data
Backup and recovery
- Creating backups
- Replaying backups
- Point-In-Time-Recovery: Replaying transaction log
