pg_bulkload

A high speed data loading tool

pg_bulkload is a third-party tool/extension designed to provide a high-speed bulk-loading capability for PostgreSQL.

It achieves a high data loading speed by inserting data directly, bypassing PostgreSQL shared buffers. However this approach has trade-offs/drawbacks, as by definition it also bypasses PostgreSQL's WAL, which increases the risk of data loss and is incompatible with replication.

Categories

Extension, Storage, Utility program

See also

COPY, pg_loader