Bengaluru, India
Percona is thrilled to support and sponsor PGConf India 2023 on a Gold level. We welcome everyone to our booth. If you plan to attend this event, stop by it and have a chat with a database expert!
Also, Percona’s Jobin Augustine will be presenting 2 talks:
In the face of economic uncertainty and a possible recession, many companies are trimming expenses, freezing hiring, and, in some cases, laying off staff.
But what if you could cut costs without negatively impacting resources or headcount? Better yet, what if you could free up enough budget to keep your existing staff and hire the quality candidates your team needs?
In this talk, Jobin Augustine, Percona’s PostgreSQL Escalation Specialist, will walk you through tried-and-tested PostgreSQL cost-cutting strategies, all designed to make an immediate impact on your bottom line.
Have you ever been in a database emergency and needed real quick pinpointing information on what is wrong with a PostgreSQL instance/database?
Are you looking for a good Analysis and meaningful conclusions using the data presented by PostgreSQL performance views (pg_stat_*)
Have you ever felt that there is too much performance and monitoring data and how to make sense of that?
If the answer is “Yes” for any or all of these. This is a presentation for you.
Contents:
- Most Important information the PostgreSQL stats views give us is their indications.
- How to effectively utilize the wait-event information to understand the problems and performance bottlenecks
- How to analyze database-level information How to analyze table and Index information
- How to check autovacuum efficiency? What are the practical problems with autovacuum tuning?
- Make meaningful ideas about table and index information.
- Explaining major problems encountered by many users
- identification of indicators of poor tuning practice.
- What data we need to collect
- Data from Host OS and how to correlate.
This presentation also includes Sharing of Simple scripts and methods for data collection and analysis.
Also, Lalit Choudhary and Sonia Valeja will give lightning talks on February 23rd at 16:40 IST and February 24th at 16:20 IST accordingly.
About the event.
PGConf India 2023 has the most awesome program ever! This conference is part of efforts to grow the PostgreSQL community by increasing awareness and providing the appropriate training and resources to further PostgreSQL adoption in India.
