Datavail is a Gold Sponsor of PGDay Chicago 2023
Look for Datavail in Chicago on April 20th, as we are sponsoring PGDay Chicago 2023.
PGDay Chicago is a non–profit, community–run conference series focused on business users, database professionals, and developers of PostgreSQL, the world’s leading open-source database. The conference delivers one day packed with presentations about PostgreSQL and related technologies.
Join us at the Convene 333 North Green Street in the Fulton market District of Chicago, IL! We’ll be there with Postgres experts on hand, showcasing our database expertise.
Top 10 Maintenance Tasks for the PostgreSQL PaaS
Presented by: Shailesh Rangani, Practice Lead for PostgreSQL
There is a myth that once databases are moved to a cloud provider, the company won’t need their database administrative (DBA) team. The idea is, “the cloud provider will manage everything.” While the cloud certainly helps with repetitive database administration tasks, repetitive tasks of database administration, there are still a large amount of tasks which need to be performed by the DBA and DevOps team.
In this session, you will learn the top 10 maintenance tasks that a PostgreSQL DBA/DevOps team still needs to take care of even when the database is migrated to a Cloud Platform as a Service (PaaS), such as Amazon RDS/Aurora, Azure Flex Server, CitusDB, and Google CloudSQL/AlloyDB.
In this session, we will cover how to monitor and proactively perform maintenance of these tasks:
- Design Best Practices
- DB Parameters Tuning
- SQL Tuning
- Tuning AutoVacuum Threshold
- Maintenance On The TABLE/INDEX Bloats
- Partition Table Maintenance & purging Data
- Index Review
- Sequence/INT Wraparound Review
- TransactionID Wraparound
Not attending the conference or looking to further explore your PostgreSQL needs? Pre-schedule a meeting with one of our experts. Simply fill out the form and we’ll confirm a time that works best for you.
Schedule Your Meeting with a Data Expert:
Check out some of our best PostgreSQL resources prior to the conference:
Migrating and Modernizing Oracle Workloads on AWS
Why & How to Migrate from Oracle to PostgreSQL
Why Your PostgreSQL Databases Should Live on Amazon Aurora
Datavail’s TechBoost Modernization Journey from SQL Server to Amazon Aurora PostgreSQL
3 Reasons to Make the Move to PostgreSQL
City: Chicago, IL
Venue: Fulton Market District
When: April 20, 2023
Time: 9:00 am CST