>> May I ask the proper (fast) way of inserting bulk data and if possible, an example would be very appreciated.
>>
>> Please note that the data I would like to insert contains arrays (float8[]).
>>
>> By the way, my environment is Windows 10, PostgreSQL 11 and compiling with Visual Studio 2017.
>
> That would be COPY:
> https://www.postgresql.org/docs/current/sql-copy.html
In particular,
copy table (col1, col2, ...) from stdin with binary
see also
https://www.postgresql.org/docs/10/static/protocol-flow.html#PROTOCOL-COPY
https://www.postgresql.org/docs/10/static/sql-copy.html#id-1.9.3.52.9.4
Also, I suggesttransaction bundling (one commit every 1000 records or so),
depending on context.
Bye,
Chris.