Call for speakers is open! Check out the CFP
Speaker:
Gayathri Paderla
Software Engineer @ Microsoft
I have experience of 15 years with Microsoft, Oracle, Marchex and Infosys. My moto towards using technology, “Tweak the technology to help, not the User/Customer requirements”. I am a very detail-oriented person, love to interact with different teams know each other and see how we can help each other. I love cooking, hiking and camping. Our family is very health oriented and we go out on walk/jog early mornings, practice healthy eating. Also, part of Team Asha, a running based Non-profit organization sheltering/educating Orphaned and Abandoned kids in India.
POSETTE 2024
Talk
Making Postgres inserts faster on Azure
In this talk you will learn how to increase the speed of your insert queries in Azure Database for PostgreSQL - Flexible Server databases.
You may have experienced frustration while waiting for your inserts to complete during migrations, daily import jobs, or within applications. There are various methods to achieve faster insert queries. Fortunately, you can alleviate this situation by implementing the following tricks:
- Creation of unlogged tables (which does not create WAL files and inserts could be fast, however if any crashes we might lose data.)
- Use a copy command for huge inserts.
- Make your inserts in batches instead of single insert commits.
- Tuning server parameters (like autovacuum, wal_buffers, max_wal_size, shared_buffers, Checkpoint_timeout).
- Do we have any constraints on the tables? If so, we need to disable them during the inserts and enable them after.
- Disable triggers if they exist before inserts if that is possible.
- Remove unused indexes from the table.
- One can also consider partitioning of tables if the table that is being inserted in is exceptionally large.
- If the activity is one time you may consider disabling HA (high availability) drop read replica and create it back after inserts.
Speaker
Interview
About the Speaker
-
Tell us about yourself: career, family, passions
PostgreSQL performance expert, including me family of 5 (husband, 2 kids, 1 pet)
-
What is your icebreaker for PostgreSQL events?
Anything performance
-
How do you prepare for an online presentation?
By rehearsing the content with my friend and prepping and reviewing the content with my manager
-
Which book are you reading right now?
80/20 rule
-
What is your favorite hobby?
cooking and dancing
About the Talk
-
What will your talk be about, exactly? Why this topic?
How to make your inserts performant. Seen many customers coming up with slow running inserts.
-
What is the audience for your talk?
Any PostgreSQL database developer/DBA
-
What existing knowledge should the attendee have?
PostgreSQL database
-
Which other talk at this year’s conference would you like to watch?
Many, anything is too less when you explore the knowledge
-
How do you balance technical depth with engaging storytelling in your conference presentations?
By starting with the issue and walking audience through the mitigation.
About PostgreSQL
-
What inspired you to work with PostgreSQL?
Interest to know about different databases.
-
What is your favorite PostgreSQL feature?
MVCC feature and Autovacuum, bgwriter....... Many more
-
What is the single thing that you think differentiates PostgreSQL most from other databases?
Configuring most of the server parameters.
-
What is your favorite PostgreSQL extension or tool? And why?
pg_partman and pg_repack both resolve most of customer issues.
-
What advice would you give to someone starting their journey with PostgreSQL?
Way to go!!! You will not look back.
-
What are your favorite resources for learning about PostgreSQL?
many, PostgreSQL internals and Github
-
PostgreSQL is open-source, did that ever help you in anyway and how?
While working for a customer issue on max_Stack_Depth, PG being Opensource helped me understand the root cause.
About POSETTE & Events
-
Have you enjoyed previous POSETTE (formerly Citus Con) conferences, either as an attendee or as a speaker?
Nope my first one ever. Earlier my manager Samay Sharma used to give talks and I used to watch them.
Subscribe to notifications to keep up with POSETTE news
Join the conversation
Use the hashtag #PosetteConf
The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).
©2024 Microsoft. All rights reserved.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.