19.21. Multi-Segment Insertion #
Warning
Multi-segment insertion is currently experimental and is not recommended for using in production.
Postgres Pro provides a configuration parameter that allows multiple backends to bulk insert data to the same table simultaneously. Refer to Multi-Segment Insertion for more information.
multi_segment_relname(string) #Specifies the name of the table for multi-segment insertion. This parameter can be set multiple times during a client session.
The table is exclusively locked after the first multi-segment insert operation and is unlocked only when all backends working in multi-segment mode disconnect from the database.