pg_bulkload
pg_bulkload copied to clipboard
ossc-db
High speed data loading utility for PostgreSQL
I'm using `pg_bulkload` to import a bunch of large (3-5 million row x 4 column) CSV files into a PostgreSQL database. The first two import very quickly and without issue,...
It seems we have a problem. A failure during trying to load into a composite type field (a record value) causes `TupleDesc` leak (I see that leaking `TupleDesc` is for...
`pg_bulkload` sometimes makes requests with unreasonable size to `palloc`, causing errors shown in the subject. What's worse, any previous error messages are overwritten, see below: I tried to load a...
Hello, This version allow users load part of the column from csv file to a postgres table. I add two parameter. One is CSV_FIELDS means columns in a csv file....
if we find a candidates, ncandidates should be assigned to 1. Otherwise ncandidates may great than 1.
1. Support importing data of text format type. 2. It supports up to 3 single byte character combination separators.
Hi, pg_bulkload does not build against v15 rc1. v15 is due in two weeks. Can you please take a look? Regards, Devrim > /usr/lib64/ccache/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-compound-token-split-by-macro -O2...
I have citus 11 env. pg_bulkload unable to loads data from csv file into citus distribute table. loading messages said no error, about 5mio records finished but count the table...
Got an error after adding then removing a column multiple times in the destination table: ``` NOTICE: BULK LOAD START ,ERROR: copy failed: ERROR: function return row and target table...
Is there a way to filter out some rows from a CSV with a FILTER or any other way? Like with Postgres COPY: ``` COPY "schema"."table" FROM 'input.csv' (format csv)...