Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions Gianni Ciolli is Vice President and Field CTO at EDB; he was Global Head of Professional Services at 2ndQuadrant until it was acquired by EDB. Gianni has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over more than 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and Open-Source software since the 1990s and is active in the community. He lives between Frankfurt and London and plays the piano in his spare time Sudheer Kumar Meesala is a lead architect at Endurance International Group and has spent the last few years designing and building scalable and secure web applications within finance and internet industries. A large part of his job has included decomposing monolithic legacy applications into microservices. This has required a deep understanding of PostgreSQL, Cassandra, and other NoSQL databases. Other key areas of interest are container orchestration, DevOps, and more. He is also an accomplished speaker and trainer. He lives in Bangalore, India, and spends far too much time in traffic jams. Sheldon Strauch is a twenty-year veteran of software consulting at companies such as IBM,Sears, Ernst & Young, and Kraft Foods. He has a Bachelor's degree in BusinessAdministration and leverages his technical skills to improve business' self-awareness. Hisinterests include data gathering, management, and mining; maps and mapping; businessintelligence; and the application of data analysis for continuous improvement. He iscurrently focused on the development of end-to-end data management and mining atEnova International, a financial services company located in Chicago. In his spare time, heenjoys the performing arts, particularly music, and traveling with his wife Marilyn.

• Table of ContentsFirst StepsExploring the DatabaseConfigurationServer ControlTables & DataSecurityDatabase AdministrationMonitoring & DiagnosisRegular MaintenancePerformance & ConcurrencyBackup & RecoveryReplication & Upgrades

Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions Gianni Ciolli is Vice President and Field CTO at EDB; he was Global Head of Professional Services at 2ndQuadrant until it was acquired by EDB. Gianni has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over more than 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and Open-Source software since the 1990s and is active in the community. He lives between Frankfurt and London and plays the piano in his spare time Sudheer Kumar Meesala is a lead architect at Endurance International Group and has spent the last few years designing and building scalable and secure web applications within finance and internet industries. A large part of his job has included decomposing monolithic legacy applications into microservices. This has required a deep understanding of PostgreSQL, Cassandra, and other NoSQL databases. Other key areas of interest are container orchestration, DevOps, and more. He is also an accomplished speaker and trainer. He lives in Bangalore, India, and spends far too much time in traffic jams. Sheldon Strauch is a twenty-year veteran of software consulting at companies such as IBM,Sears, Ernst & Young, and Kraft Foods. He has a Bachelor's degree in BusinessAdministration and leverages his technical skills to improve business' self-awareness. Hisinterests include data gathering, management, and mining; maps and mapping; businessintelligence; and the application of data analysis for continuous improvement. He iscurrently focused on the development of end-to-end data management and mining atEnova International, a financial services company located in Chicago. In his spare time, heenjoys the performing arts, particularly music, and traveling with his wife Marilyn.

• Table of ContentsFirst StepsExploring the DatabaseConfigurationServer ControlTables & DataSecurityDatabase AdministrationMonitoring & DiagnosisRegular MaintenancePerformance & ConcurrencyBackup & RecoveryReplication & Upgrades

Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions Gianni Ciolli is Vice President and Field CTO at EDB; he was Global Head of Professional Services at 2ndQuadrant until it was acquired by EDB. Gianni has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over more than 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and Open-Source software since the 1990s and is active in the community. He lives between Frankfurt and London and plays the piano in his spare time Sudheer Kumar Meesala is a lead architect at Endurance International Group and has spent the last few years designing and building scalable and secure web applications within finance and internet industries. A large part of his job has included decomposing monolithic legacy applications into microservices. This has required a deep understanding of PostgreSQL, Cassandra, and other NoSQL databases. Other key areas of interest are container orchestration, DevOps, and more. He is also an accomplished speaker and trainer. He lives in Bangalore, India, and spends far too much time in traffic jams. Sheldon Strauch is a twenty-year veteran of software consulting at companies such as IBM,Sears, Ernst & Young, and Kraft Foods. He has a Bachelor's degree in BusinessAdministration and leverages his technical skills to improve business' self-awareness. Hisinterests include data gathering, management, and mining; maps and mapping; businessintelligence; and the application of data analysis for continuous improvement. He iscurrently focused on the development of end-to-end data management and mining atEnova International, a financial services company located in Chicago. In his spare time, heenjoys the performing arts, particularly music, and traveling with his wife Marilyn.

• Table of ContentsFirst StepsExploring the DatabaseConfigurationServer ControlTables & DataSecurityDatabase AdministrationMonitoring & DiagnosisRegular MaintenancePerformance & ConcurrencyBackup & RecoveryReplication & Upgrades