FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Debian > Debian Development

 
 
LinkBack Thread Tools
 
Old 05-29-2012, 10:20 PM
Alexander Kuznetsov
 
Default Bug#675106: ITP: pgbulkload -- A high speed data loading utility for PostgreSQL

Package: wnpp
Severity: wishlist
Owner: Alexander Kuznetsov <acca@cpan.org>

* Package name : pgbulkload
Version : 3.1.1
Upstream Author :
Takahiro Itagaki itagaki.takahiro @nospam@ gmail.com
Masao Fujii masao.fujii @nospam@ gmail.com
Mitsuru Hasegawa hasegawa @nospam@ metrosystems.co.jp
Masahiko Sakamoto sakamoto_masahiko_b1 @nospam@ lab.ntt.co.jp
Toru SHIMOGAKI shimogaki.toru @nospam@ oss.ntt.co.jp
* URL : http://pgfoundry.org/projects/pgbulkload/
* License : BSD
Programming Lang: C, SQL
Description : A high speed data loading utility for PostgreSQL
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.
.
The original goal of pg_bulkload was an faster alternative of COPY command in
PostgreSQL, but version 3.0 or later has some ETL features like input data
validation and data transformation with filter functions.
.
In version 3.1, pg_bulkload can convert the load data into the binary file
which can be used as an input file of pg_bulkload. If you check whether
the load data is valid when converting it into the binary file, you can skip
the check when loading it from the binary file to a table. Which would reduce
the load time itself. Also in version 3.1, parallel loading works
more effectively than before.



--
To UNSUBSCRIBE, email to debian-devel-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20120529222006.19901.16867.reportbug@assa103.local ">http://lists.debian.org/20120529222006.19901.16867.reportbug@assa103.local
 

Thread Tools




All times are GMT. The time now is 12:27 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org