On 1/25/2010 8:12 PM, Craig Ringer wrote:
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
Even better is to use COPY to load large chunks of data. libpq provides
access to the COPY interface if you feel like some C coding. The JDBC
driver (dev version only so far) now provides access to the COPY API, so
you can also bulk-load via Java very efficiently now.
--
Craig Ringer
I recall seeing someplace that you can avoid WAL if you start a
transaction, then truncate the table, then start a COPY.
Is that correct? Still hold true? Would it make a lot of difference?
(Also, small plug, perl supports the COPY api too)
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
