[et_pb_section fb_built=”1″ specialty=”on” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column type=”3_4″ specialty_columns=”3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_row_inner module_class=”top-row-res” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”23px||19px|||” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=” Aug 26, 2022 to Aug 27, 2022″ use_icon=”on” font_icon=”||fa||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” _builder_version=”4.18.0″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” global_colors_info=”{}”][/et_pb_blurb][et_pb_blurb title=”Brazil” use_icon=”on” font_icon=”||divi||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” _builder_version=”4.18.0″ _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” global_colors_info=”{}”][/et_pb_blurb][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner _builder_version=”4.18.0″ _module_preset=”default” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”]
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.
[/et_pb_text][et_pb_button button_url=”https://www.pgconf.com.br/2022/” button_text=”Go to event link” _builder_version=”4.18.0″ _module_preset=”default” custom_button=”on” button_text_size=”14px” button_text_color=”#FFFFFF” button_bg_color=”#00162B” button_border_width=”0px” button_icon=”||fa||900″ button_icon_placement=”left” button_on_hover=”off” custom_padding=”5px|15px|5px|35px|false|false” global_colors_info=”{}”][/et_pb_button][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_title title=”off” meta=”off” _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][/et_pb_post_title][/et_pb_column][/et_pb_section]
