Problem in inserting more number of records if it is transaction based

Question

In our application we allow user to enter email ids comma separated. We take the email ids separate it and insert as records in a table.

When they enter email ids less than 10000, everything goes fine. If it goes beyond 10000 the whole application hangs, we are not able to login the application.

Technical Details

1. Java Servlet and JSP running in Tomcat server.
2. Database - Postgres

Note: The whole insert process is transaction based, that is if we face any problem in inserting a single email id and the insert fails the whole inserts roles back.

Answer 1

Sounds like an applicationproblem, PostgreSQL has no problem with 10k new records within a single transaction. We load GBs of data within a single transaction, works great.

Answer 2

The problem is with transaction block. When we removed the transaction block, the inserts were also fast. As well as application was also working fine.

Thanks for answering.