Next Meetup

WHEN and WHY we need vacuum/autovacuum
WHEN and WHY we need vacuum/autovacuum As we all know, VACUUM is one of the critical maintenance activities that PostgreSQL instance needs to improve the performance. However, we must understand how PostgreSQL deals with VACCUM before we setup any maintenance plans. So, this topic covers: - What is fragmentation/Bloat - How to find bloat in database - Vacuum modes i.e. Different kinds of VACUUMs - When and why do we need vacuum/autovacuum - Difference between vacuum/autovacuum/vacuum full - Why we need a manual vacuum sometimes though there is autovacuum - How default autovacuum settings works. - Use cases to change autovacuum default settings - How to improve VACUUM performance. - Monitoring autovacuum/vacuum executions Note: For online participants please connect through Amazon Chime: 1. Click to join the meeting: Meeting ID:[masked] 2. You can use your computer’s microphone and speakers, however, a headset is recommended. Or, call in using your phone: India Toll-Free:[masked] Meeting PIN:[masked] One-click Mobile Dial-in (India Toll-Free):[masked],,[masked]# International: 3. To connect from an in-room video system, use one of the following Amazon Chime bridges: SIP video system: or H.323 system:[masked] Meeting PIN:[masked]# About the Speaker: Swanand Kshirsagar Swanand is an AWS certified Solutions Architect, currently working as an Associate Consultant with AWS Professional Services with over 11 years of total IT experience in Database administration with technologies like Oracle, SQL Server and mainly - PostgreSQL in diverse domains. He has worked on various projects involving PostgreSQL such as - Database architecture setup on-prem & cloud, Disaster Recovery and HA setup, database migrations & performance tuning. He has also executed several architectural health checks across different clients globally.

Amazon Development Centre India Pvt Ltd

Divyashree Solitaire Madhapur, Sherlingampally Mandal · Hyderabad

    Past Meetups (26)

    What we're about

    Meet with the PostgreSQL community in Hyderabad. Share challenges, find solutions. Enhance knowledge and skill. Network with PostgreSQL professionals.

    Members (327)

    Photos (1)