Register now or log in to join your professional community.
Database Engine: PostgreSQL
you can Use SQL SCRIPT wich is a set of SQL commands saved as a file in SQL Scripts. A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL Scripts to create, edit, view, run, and delete script files.
at last in script file use commit or commitretaining for validation of all operation
Explore clustering. Thats one option
that depends on your requirement. Normally Database row locking along with transactions are used for concurrent inserts.
