Name: Deep Dive into PostgreSQL Indexing
Start: 2022-03-02T11:00:00Z
End: 2022-03-02T11:00:59.000Z
Location: BrightTALK
Rating: 5

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona provides single-source expertise in multi-vendor environments that eliminates lock-in, increases agility and enables business growth.

Percona Monitoring and Management (PMM) is known for its great monitoring functionality. However, its integrated alerting capability is limited and sometimes complex to manage.

Alertmanager handles alerts sent by client applications. It deduplicates, groups, and routes those alerts to different receivers, such as email, PagerDuty, and OpsGenie. 

 Join Percona Experts Ananias Tsalouchidis, Principal DBA in Managed Services, and Tibor Korocz, Architect in Managed Services to learn how you can use Alertmanager to build a powerful platform that alerts you over multiple communication channels if a simple health check fails or a pattern change occurs that may indicate an issue.

Build a Powerful Alerting Platform by Integrating Alertmanager with PMM

Whether you’re looking to mitigate vulnerabilities or take advantage of new features, benefits, and fixes, upgrading MySQL is essential. However, major version upgrades can be problematic if they haven't been well tested with your application, as the procedure may break it, render it inoperable, or cause performance issues.

In this webinar, Percona Experts - Alison Savage, DBA Manager and Arunjith Aravindan, Senior MySQL DBA will share best practices for ensuring your major MySQL upgrades run smoothly.

How to Ease Major MySQL Upgrades

Whether you’re looking to mitigate vulnerabilities or take advantage of new features, benefits, and fixes, upgrading MySQL is essential. However, major version upgrades can be problematic if they haven't been well tested with your application, as the procedure may break it, render it inoperable, or cause performance issues.

In this webinar, Percona Experts — Alison Savage, DBA Manager and Arunjith Aravindan, Senior MySQL DBA — will share best practices for ensuring your major MySQL upgrades run smoothly.

You’ve already deployed Percona Monitoring and Management (PMM).  You’ve mastered the basics. Now what? 

Join Michael Coburn, Percona Principal Architect, and Francisco Bordenave, Percona Senior Architect, as they teach you how to get the most out of PMM. 

You’ll learn how to use PMM to: 

- build a custom dashboard from scratch 
- leverage custom queries for MySQL and Postgres to plot data unique to your dataset
- use the textfile collector to pull in data you generate from a shell script 

… and more

Advanced Percona Monitoring and Management (PMM) Usage

Want to know how to deploy PostgreSQL environments and get any version up and running within minutes or even seconds?

Join Agustin Gallego, Percona Senior Support Engineer, to see the cool tools Percona Support uses to efﬁciently deploy everything from standalone servers and complex replication to high availability topologies.

You’ll walk away with all the knowledge you need to start testing your applications against fully functional PostgreSQL instances fast.

Efficiently Deploying PostgreSQL Instances: The Evolution

MySQL 8 just keeps getting better with new enhancements that further improve operations. Join Vinicius Grippa, Lead Senior Support Engineer in Support at Percona for this talk as he covers the latest MySQL features and how you can extract their full potential. 

Features to be discussed include:

- DDL improvements such as parallelization
- new server status variables (to improve monitoring and health analysis) 
- Performance Schema instrumentation
- DROP / TRUNCATE operations
- REDO log capabilities (archiving, disabling) 
- EXPLAIN tree format
- Parallel read thread
- INSTANT algorithm

MySQL 8 New Features

Database complexity keeps escalating, but did you know there’s a way to simplify management and maximize performance? 

Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB. PMM helps you simplify operations, optimize performance, and improve the security of your databases.

In this session, David Stokes, Percona Technical Evangelist, starts at zero and makes you a hero at monitoring all your open source databases. You learn how to:

- install PMM 
- register databases with it
- simplify operations and optimize performance
- improve the security of your database services

Percona Monitoring and Management (PMM) for Novices

The fourth edition of the MySQL Cookbook was just released, and co-author Sveta Smirnova, Principal MySQL Support Engineer at Percona, is sharing some of the most popular recipes. 

Join us for this Percona Live replay session and hear Sveta demonstrate how to solve specific data-related issues, including: 

- a few tasks with different priorities, such as JSON in MySQL for those who need flexibility 
- modern SQL for analytics, and group replication for high availability
- writing programs using JavaScript and Python languages, X DevAPI, and MySQL Shell

MySQL Cookbook: Recipes for Your Business

Good database design is essential to building scalable, high-performance applications. Not only does it help maintain data consistency and accuracy while increasing reliability, it also makes the database easier to use and maintain. 

Join Jobin Augustine, PostgreSQL Escalation Specialist at Percona, as he discusses database design best practices and how to avoid common mistakes like:

- Poor selection of data types
- Underestimating the impact of unused indexes
- Default assumptions 

…and more!

PostgreSQL Database Design Best Practices

PostgreSQL databases require periodic maintenance known as vacuuming. Vacuuming compacts and optimizes dead space, which can greatly speed up performance. 

But vacuuming can also degrade performance. 

Join Charly Batista, PostgreSQL Tech Lead at Percona, for this technical session on vacuuming your PostgreSQL databases without negatively impacting performance. 

He’ll cover: 

- Why you need to vacuum
- When and how to schedule vacuuming
- Tools you can leverage to monitor for related issues

So stop worrying and learn to love the vacuum!

Using Vacuum to Clean Up Postgres for Performance

Every company’s viability depends on security. But security is a broad topic, and understanding your options, particularly when it comes to databases, can be challenging. 

Join Robert Bernier, Percona’s Professional Services Consultant as he discusses a “big picture” view of Postgres security. We’ll walk through the principles of security and, in doing so, outline the approaches and technology available for securing this database management system. 

Topics covered include: 
- Why securing the database itself is foundational to protecting your IP
- The key competencies of database security– the database system, the operating system, and the network. 
- Why effective security equals robust and performant architecture  
- Best practices and missteps to avoid

PostgreSQL Security Missteps and Tips

At Percona, we’ve helped hundreds of companies maximize their PostgreSQL database performance. So it shouldn’t be surprising we’ve seen the same (avoidable) mistakes play out time and again. 

In How to Avoid the 10 Deadly PostgreSQL Mistakes, Percona’s Matt Yokovic, Head of Open Source Strategy (the HOSS), and Barrett Chambers, Director, Solutions Engineering, will explain how to avoid the most common (and not so common) mistakes plaguing PostgreSQL architecting. 

They’ll cover: 
- 10 must-know PostgreSQL mistakes–why they matter and how to avoid them
- Achieving better performance, cost, and security 
- Key considerations for continued success 

…and more.

How to Avoid the 10 Deadly PostgreSQL Mistakes

PostgreSQL has often been called the most advanced open source database in the world. However, many organizations have complex environments that require deep, actionable insights into their applications and databases to ensure that everything is running optimally. 

Percona Monitoring and Management (PMM) is an open source database monitoring, observability and management solution that allows users to observe and understand the health of their systems, explore new patterns in database behavior and perform database management operations no matter where they are located - on-premises or in the cloud.

Join Charly Batista, PostgreSQL Tech Lead and Agustin Gallego, Senior Support Engineer for this talk that will:

- Demonstrate how to set up and use PMM to make the most out of your PostgreSQL deployments
- Review the built-in metrics and dashboards, and teach you how to customize it for your environment
- Show you how to troubleshoot ongoing issues or do root cause analysis whenever you need to
After attending the talk, you will be able to spot critical performance issues in PostgreSQL faster, understand the root cause of these problems better, and resolve them more efficiently.

How to Improve PostgreSQL Monitoring and Observability with PMM

ndexes are a fundamental feature of relational databases and PostgreSQL offers developers and designers a rich collection of options. But not all indexes are appropriate for all circumstances. Using a ‘wrong’ index can have the opposite effect to what you intend, and problems might only surface once in production. 



Armed with more advanced knowledge, you can avoid this worst-case scenario! 



Join Ibrar Ahmed, Senior Software Architect at Percona for this technical session as he takes a deep dive into indexing to show you: 



- How to compare index types and apply them to different application scenarios
- How to use pg_stat_statment to find opportunities for adding indexes to your database 
- Best practices for database index strategy and design

Deep Dive into PostgreSQL Indexing

Open Source

PostgreSQL

Database Management

indexing

Cloud computing has exploded over the past few years, delivering a previously unimagined level of workplace mobility and flexibility. The cloud computing community on BrightTALK is made up of thousands of engaged professionals learning from the latest cloud computing research and resources. Join the community to expand your cloud computing knowledge and have your questions answered in live sessions with industry experts and vendor representatives.

Cloud Computing

The IT security community on BrightTALK is composed of more than 200,000 IT security professionals trading relevant information on software assurance, network security and mobile security. Join the conversation by watching on-demand and live information security webinars and asking questions of experts and industry leaders.

IT Security

Enterprise applications have become a crucial piece of infrastructure for many businesses. The enterprise applications community on BrightTALK features the latest insights in enterprise application integration, enterprise application architecture and EAS software. Join the community to gain access to thousands of videos and webinars presented by recognized enterprise information systems experts and arm yourself with the knowledge you need to succeed.

Enterprise Applications

Welcome to the big data and data management community on BrightTALK. Join thousands of data quality engineers, data scientists, database administrators and other professionals to find more information about the hottest topics affecting your data. Subscribe now to learn about efficiently storing, optimizing a complex infrastructure, developing governing policies, ensuring data quality and analyzing data to make better informed decisions. Join the conversation by watching live and on-demand webinars and take the opportunity to interact with top experts and thought leaders in the field.

Big Data and Data Management

As an IT professional, many of the problems you face are multifaceted, complex and don’t lend themselves to simple solutions. The information technology community features useful and free information technology resources. Join to browse thousands of videos and webinars on ITIL best practices, IT security strategy and more presented by leading CTOs, CIOs and other technology experts.

Deep Dive into PostgreSQL Indexing

Presented by

About this talk

Percona