how to competently vacuum a distributed DBMS and avoid serious problems

how to competently vacuum a distributed DBMS and avoid serious problems

On February 8 at 11:00 Moscow time, a practical webinar “Database Management in Greenplum: Monitoring and Debris Removal” will be held, where ITSumma experts will share their experience of working with this popular DBMS for storing large volumes of data.

In the program:

  • Why is the vacuuming procedure needed in the column-oriented DBMS Greenplum and how does it differ from PostgreSQL vacuuming.

  • What serious problems can be caused by improper or insufficiently frequent vacuuming of a distributed database.

  • Why there is no automatic background vacuuming in Greenplum and how it affects the administration features.

  • How to correctly configure and run the VACUUM procedure in GPDB, recommendations for developers and database administrators.

  • How to track the need for vacuuming and monitor its impact on the DBMS.

  • How to organize a general vacuuming strategy in the company.

  • At the webinar, you will be able to ask the lecturer questions and discuss topics of interest in real time.

Webinar speakers:

Oleksiy Ponomarevsky, leading database administrator at ITSumma

Ivan Khazyainov, Head of Big Data at ITSumma

Register for the Greenplum Webinar: Vacuuming a Distributed DBMS → https://clck.ru/38NbC3

Related posts