Aug 26, 2022 to Aug 27, 2022
Brazil
Percona is thrilled to support PGConf.Brazil this year. Our team will bring the best experts to meet attendees on the Percona booth and advise on open source technologies. Also, we will bring some nice swag to give it out among Postgres lovers. Charly Batista, Postgres Tech Lead, is a part of the evaluation committee and will participate in the choice of talks for the event. We would love to see you all there!
Also, Percona speakers will present several talks:
-
Efficiently Deploying PostgreSQL Instances by Agustín Gallego
We will review how to deploy PostgreSQL environments and be able to have any version of PostgreSQL running within minutes… or even seconds! You will learn what cool tools the Percona Support team uses to efficiently deploy everything from standalone servers to more complex replication and HA topologies.
After attending, you will have all the knowledge you need to start testing your applications against fully functional PostgreSQL instances… fast!
-
I dropped my database! Now what? – A dive into PostgreSQL backup using pgbackrest and how to use it for PITR by Charly Batista.
We live in a dangerous world and a catastrophe can happen at any time, including in our database. We can have a hardware failure, software failure, malicious software, or a human error and find ourselves with a data loss. While we work hard to prevent all those some are just not under our control and we cannot rely on luck, we need strategy and methods to be able to recover the maximum data we can in case a catastrophic event happens and this is what we will discuss during this talk. How to survive catastrophic events and recover data back!
-
Boosting performance with Window Functions and CTEs by Charly Batista and Breno Baima (Vox Tecnologia)
Window Functions and CTEs are extremely powerful features and few people use them extensively. Often due to lack of knowledge, other times because they do not realize the benefit they can have.
A well-built query can have a significant performance gain just by reducing the number of calls the application makes to the Database and complex queries that would often be written as 2, 3 or more distinct queries can be rewritten into 1 single query using – if these resources
About the event.
PGConf.Brasil will take place on August 26th and 27th in Sao Jose dos Campos. It is a world-class conference, which builds on the efforts of professionals and enthusiasts to expand the community of PostgreSQL, enabling participants to develop new knowledge through lectures and training.
