VerticaBulkImportPseudoTableType

This enum defines the type of staging (pseudo) table created during bulk-import operations. It applies only to Vertica.

It is used by the following bulk operations, all part of RepoDb.Vertica.BulkOperations.

BulkDelete
BulkDeleteByKey
BulkInsert (only when identityBehavior is ReturnIdentity)
BulkMerge
BulkUpdate

Enum Values

Name	Description
Auto	Chooses between `Physical` and `Memory` based on row count (`Physical` at 5,000 rows or more). This is the default.
Memory	Backs the operation with a Vertica `GLOBAL TEMPORARY TABLE ... ON COMMIT PRESERVE ROWS`. Rows are private to the connection that wrote them.
Physical	Backs the operation with an ordinary heap table. Faster to create for very large row counts than a global temporary table’s per-connection storage, at the cost of the rows briefly existing as an ordinary (if uniquely-named) table.

Every pseudo table is created with a per-call unique name, so unlike some other providers’ bulk-operations packages, Physical and Memory are both safe for concurrent callers writing against the same target table — there is no shared, deterministic staging-table name for them to race on.

Usability

Pass the value to the pseudoTableType argument of the target operation.

using (var connection = new VerticaConnection(connectionString))
{
    var people = GetPeople(1000);
    var insertedRows = connection.BulkInsert(people,
        identityBehavior: VerticaBulkImportIdentityBehavior.ReturnIdentity,
        pseudoTableType: VerticaBulkImportPseudoTableType.Physical);
}