Making Postgres inserts faster on Azure | POSETTE 2024

From the creator

Video of a conference talk about making Postgres inserts faster on Azure presented by Gayathri Paderla at POSETTE: An Event for Postgres 2024. 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. -- Gayathri has 15 years of experience with Microsoft, Oracle, Marchex and Infosys. Her motto towards using techno

Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.