POSQLP - PostgreSQL Performance

Základní informace
Přihlásit se na kurz

Popis kurzu

This training teaches how to safely and effectively optimize the performance of PostgreSQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

Obsahová náplň

Hardware and Disks

  • Physical disk anatomy
  • Filesystems
  • Performance considerations with disks
  • Tuning disks for better performance

Transactions and locks

  • Locking and concurrency
  • Write ahead logs
  • Data sync options
  • Checkpoints

Operating system

  • Tuning operating system
  • Memory, work memory and index memory

Indexes and Query planner

  • Examining query planner
  • Index types and their usage
  • Full text searh
  • Planner statistics
  • Table partitioning

Replication overview

  • Log shipping and

Additional tools

  • pgbench

Termíny kurzů

15.04.2019 - 17.04.2019
07.10.2019 - 09.10.2019

Kontakt a místo konání

Kontaktní údaje
Martina Dubcov_
e-mail:
martina.dubcova@... Zobrazit


Adresa
Bělehradská 54, 120 00 Praha 2

O organizátorovi

Kontaktní údaje
tel:
+420 731 175 *** Zobrazit

mobil:
+420 731 175 *** Zobrazit

e-mail:
edu@... Zobrazit


Adresa
EDU Trainings s.r.o.
Bělehradská 347/54, Praha 2 Zobrazit na mapě

Hodnocení kurzu

(hlasujte)