PostgreSQL DBA

https://sparktpoint.com/postgresql-partition-by/ PARTITION BY in PostgreSQL

https://www.postgresql.fastware.com/postgresql-insider-prt-ove Partitioning

https://www.timescale.com/learn/when-to-consider-postgres-partitioning When to Consider Postgres Partitioning

https://rasiksuhail.medium.com/guide-to-postgresql-table-partitioning-c0814b0fbd9b#:~:text=Hash%20partitioning%20in%20PostgreSQL%20is,Partition%20makes%20querying%20faster. Guide to PostgreSQL Table Partitioning

https://www.cybertec-postgresql.com/en/how-to-corrupt-your-postgresql-database/ How to corrupt your PostgreSQL database

https://www.highgo.ca/2021/01/27/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-1/ Avoiding, Identifying, and dealing with PostgreSQL database corruption

https://www.linkedin.com/pulse/understanding-data-corruption-postgresql-shyam-kumar-9kvwc Understanding Data Corruption in PostgreSQL

https://akashcsharma.medium.com/demystifying-database-internals-part-2-deep-dive-into-storage-engine-of-dbms-episode-i-paging-2f748a078d22 Deep dive into Storage Engine of DBMS Episode I(Paging, Buffer Pool Manager, Write Ahead Log)

https://www.youtube.com/watch?v=sP5nbdNxaQc A PostgreSQL fork for horizontal scalability

The postmaster ID will be assigned once the cluster is started based on this ID other background processes will starts and running on different ID with the same parent ID. This postmaster ID will changes when the cluster is stop and starts.

https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases A list of PostgreSQL derived forks and rebranded distributions in alphabetical order.

https://www.youtube.com/watch?v=TAtfkrjtAYM Journey to data insight | Four principles to guide you

https://www.youtube.com/watch?v=3v7NhwhXIyE Data Preparation | Data Journey | 7 Challenges of Big Data Analytics

https://www.youtube.com/watch?v=KCEPoPJ8sWw Big Data Full Course 2022 | Big Data Tutorial For Beginners

https://youtu.be/nGAG5kqlM5E Introduction to Big Data Techniques