| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ~Get Your Files Here ! | |||
| 01. Tuning PostgreSQL configuration and environment | |||
| 01. Introducing PostgreSQL configuration and tuning.mp4 | 4 MB | ||
| 01. Introducing PostgreSQL configuration and tuning.srt | 3.3 KB | ||
| 02. Inspecting important config settings.mp4 | 6.6 MB | ||
| 02. Inspecting important config settings.srt | 4 KB | ||
| 02. Query performance and indexing | |||
| 01. Introducing performance problems and polutions.mp4 | 2.6 MB | ||
| 01. Introducing performance problems and polutions.srt | 2.3 KB | ||
| 02. Demo 1 - Looking at a poorly-performing query.mp4 | 6.4 MB | ||
| 02. Demo 1 - Looking at a poorly-performing query.srt | 3.8 KB | ||
| 03. Demo 2 - Evaluating execution plans.mp4 | 15.1 MB | ||
| 03. Demo 2 - Evaluating execution plans.srt | 7.9 KB | ||
| 03. Monitoring, locking, and maintenance | |||
| 01. Introducing monitoring and maintenance in PostgreSQL.mp4 | 1.7 MB | ||
| 01. Introducing monitoring and maintenance in PostgreSQL.srt | 1.6 KB | ||
| 02. Demo 1 - Finding high-impact queries with pg_stat_statements.mp4 | 6.2 MB | ||
| 02. Demo 1 - Finding high-impact queries with pg_stat_statements.srt | 3.4 KB | ||
| 03. Demo 2 - Understanding logging.mp4 | 9.1 MB | ||
| 03. Demo 2 - Understanding logging.srt | 5.8 KB | ||
| 04. Demo 3 - Handling locking and blocking like a DBA.mp4 | 7.9 MB | ||
| 04. Demo 3 - Handling locking and blocking like a DBA.srt | 5.2 KB | ||
| 04. Securing PostgreSQL in production | |||
| 01. Introducing PostgreSQL security.mp4 | 4.2 MB | ||
| 01. Introducing PostgreSQL security.srt | 3.6 KB | ||
| 02. Authenticating database users for control and auditing.mp4 | 8.2 MB | ||
| 02. Authenticating database users for control and auditing.srt | 5 KB | ||
| 03. Encrypting data in transit to protect it on the wire.mp4 | 6.7 MB | ||
| 03. Encrypting data in transit to protect it on the wire.srt | 4.6 KB | ||
| 04. Controlling network exposure to shut out unwanted intruders.mp4 | 8.1 MB | ||
| 04. Controlling network exposure to shut out unwanted intruders.srt | 5.1 KB | ||
| 05. Restricting privileges to protect data.mp4 | 9.4 MB | ||
| 05. Restricting privileges to protect data.srt | 6.2 KB | ||
| 06. Troubleshooting permission problems.mp4 | 8 MB | ||
| 06. Troubleshooting permission problems.srt | 5.2 KB | ||
| 07. Understanding extension security.mp4 | 5.6 MB | ||
| 07. Understanding extension security.srt | 4.1 KB | ||
| 08. Monitoring security events.mp4 | 8.6 MB | ||
| 08. Monitoring security events.srt | 5.1 KB | ||
| 09. Restricting access to table rows.mp4 | 5.9 MB | ||
| 09. Restricting access to table rows.srt | 3.8 KB | ||
| 10. Putting it all together.mp4 | 1.6 MB | ||
| 10. Putting it all together.srt | 1.3 KB | ||
| 05. Demo 4 - Getting your arms around MVCC.mp4 | 7.5 MB | ||
| 05. Demo 4 - Getting your arms around MVCC.srt | 4.8 KB | ||
| 06. Demo 5 - Monitoring AUTOVACUUM.mp4 | 9.3 MB | ||
| 06. Demo 5 - Monitoring AUTOVACUUM.srt | 6.9 KB | ||
| 07. Expecting continuous improvement in PostgreSQLs monitoring tools.mp4 | 4 MB | ||
| 07. Expecting continuous improvement in PostgreSQLs monitoring tools.srt | 4.2 KB | ||
| 04. Demo 3 - Investigating indexing.mp4 | 13.7 MB | ||
| 04. Demo 3 - Investigating indexing.srt | 7.3 KB | ||
| 05. Demo 4 - Building covering and partial indexes.mp4 | 13.4 MB | ||
| 05. Demo 4 - Building covering and partial indexes.srt | 6.9 KB | ||
| 06. Demo 5 - Including data columns.mp4 | 10.8 MB | ||
| 06. Demo 5 - Including data columns.srt | 7.3 KB | ||
| 07. Demo 6 - Designing indexes for JSON workloads.mp4 | 12.4 MB | ||
| 07. Demo 6 - Designing indexes for JSON workloads.srt | 7.7 KB | ||
| 08. Demo 8 - Mazimizing indexing but minimizing performance.mp4 | 11.1 MB | ||
| 08. Demo 8 - Mazimizing indexing but minimizing performance.srt | 6.3 KB | ||
| 09. Demo 9 - Rewriting queries for better plans.mp4 | 11.4 MB | ||
| 09. Demo 9 - Rewriting queries for better plans.srt | 6.3 KB | ||
| 10. Demo 10 - Understanding how table statistics affect the optimizer.mp4 | 12.2 MB | ||
| 10. Demo 10 - Understanding how table statistics affect the optimizer.srt | 7.4 KB | ||
| 11. Demo 11 - Diagnosing concurrency bottlenecks.mp4 | 9.9 MB | ||
| 11. Demo 11 - Diagnosing concurrency bottlenecks.srt | 6.8 KB | ||
| 03. Considering memory usage.mp4 | 3.5 MB | ||
| 03. Considering memory usage.srt | 3.7 KB | ||
| 04. Managing the PostgreSQL configuration.mp4 | 4.9 MB | ||
| 04. Managing the PostgreSQL configuration.srt | 3.3 KB | ||
| 05. Understanding how the query planner considers disk usage.mp4 | 6.3 MB | ||
| 05. Understanding how the query planner considers disk usage.srt | 4.6 KB | ||
| 06. Introducing autovacuum.mp4 | 9 MB | ||
| 06. Introducing autovacuum.srt | 5.3 KB | ||
| 07. Mitigating transaction ID wraparound.mp4 | 6.2 MB | ||
| 07. Mitigating transaction ID wraparound.srt | 4.4 KB | ||
| 08. Understanding checkpointing.mp4 | 6.8 MB | ||
| 08. Understanding checkpointing.srt | 4.6 KB | ||
| 09. Controlling write-ahead logging.mp4 | 6.7 MB | ||
| 09. Controlling write-ahead logging.srt | 4.4 KB | ||
| 10. Managing database connections.mp4 | 6.2 MB | ||
| 10. Managing database connections.srt | 4.3 KB | ||
| 11. Planning for virtualization and PostgreSQL version 18.mp4 | 3.9 MB | ||
| 11. Planning for virtualization and PostgreSQL version 18.srt | 4.1 KB |
PostgreSQL Performance Tuning and Security Hardening
https://WebToolTip.com
Released 7/2026
By Gerald Britton
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 2h 8m 3s | Size: 298.7 MB
Learn to transform an average PostgreSQL system into one that is fast, stable, and production-ready.
Learn to transform an average PostgreSQL system into one that is fast, stable, and production-ready. In this course, PostgreSQL Performance Tuning and Security Hardening, you'll learn how to improve the performance and security of PostgreSQL databases in real-world environments. First, you'll explore tuning a PostgreSQL configuration to better align with your hardware and workload. Then, you’ll see how to analyze and optimize queries using execution plans and effective indexing strategies. Finally, you’ll learn to maintain performance over time and secure your database through proper authentication, access control, and configuration. By the end of this course, you’ll know how to diagnose and fix slow queries, configure PostgreSQL for consistent performance, monitor and maintain database health, and apply security best practices to protect your data in production.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - PostgreSQL DBA Backup, Recovery, PITR and Performance Tuning Posted by
freecoursewb in Other
|
746.3 MB | freecoursewb | 2 years | 2 | 0 |
All Comments