search

kamranahmedse / developer-roadmap

Interactive roadmaps, guides and other educational content to help developers grow in their careers.
https://roadmap.sh
Other
295.24k stars 39.01k forks source link

[Suggestion] PostgreSQL DBA #3834

Closed robinportigliatti closed 1 year ago

robinportigliatti commented 1 year ago

Hello,

In Query Analysis you should talk about PEV2 instead of PEV. PEV project seems to be abandonned.

You should talk about explain.dalibo.com when talking about PEV2.

Data partitionning and Sharding should not be on the same level. The first is basic and the other one is an advanced concept.

In Log Analysis, you should also talk about pgCluu from Gilles Darold.

In migration tools you should talk about ora2pg from Gilles Darold.

Edit: You should also talk about check_pgactivity, temboard, check_pgbackrest in Monitoring.

As for Develop Infrastructure skills you could talk about pglift and its ansible collection.

You can also create a topic about anonymisation with PostgreSQL anonymizer

You should talk about terraform and not only docker.

Robin,

kamranahmedse commented 1 year ago

Thank you -- that was really helpful. Updates have been made.

pgiraud commented 1 year ago

Thanks for adding this.

Unfortunately, what's written for PEV2 and explain.dalibo.com is partially wrong. Looks like the purpose of those projects is not understood correctly.

For example, there's no relation between those projects and depesz.

Also PEV2 doesn't allow plans to be shared. It only does the parsing and graphical vizualization. Explain.dalibo.com (which uses PEV2 to display the plan) does allow plans sharing.