Use postgres Transactions to optimize bulk insertions

[DieHard073055]

By bundling many insertions into a single transaction, you reduce the overhead of transactional logging. Each individual transaction (commit) in PostgreSQL involves disk I/O operations for logging, so reducing the number of commits can speed up bulk operations.

Here is an example

// initiate the transaction
let mut tx = pool.begin().await?;

// execute a query into the transaction
sqlx::query!("INSERT INTO your_table (column1, column2) VALUES ($1, $2)", value1, value2)
    .execute(&mut tx)
    .await?;

// execute more queries if you have any

// Then commit the transaction when you are done.
tx.commit().await?;