Sunday, November 20, 2011

Postgresql - pg_bulkload

pg_bulkload -- it provides high-speed data loading capability to PostgreSQL users.
pg_bulkload is designed to load huge amount of data to a database. You can choose whether database constraints are checked and how many errors are ignored during the loading. For example, you can skip integrity checks for performance when you copy data from another database to PostgreSQL. On the other hand, you can enable constraint checks when loading unclean data.

It could be a good option for loading data in our future ETL's. It also supports parallel loading.

No comments:

Post a Comment