Horton

Re: Savepoints in transactions for speed?

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Mike Blackwell <mike.blackwell@rrd.com>
Cc: pgsql-performance@postgresql.org
Date: 2012-11-27T22:52:20Z
Lists: pgsql-performance 
On 27/11/12 22:04, Mike Blackwell wrote:
> I need to delete about 1.5 million records from a table and reload it 
> in one transaction.

> The data to reload the table is coming from a Perl DBI connection to a 
> different database (not PostgreSQL) so I'm not sure the COPY 
> alternative applies here.
No reason why it shouldn't.

https://metacpan.org/module/DBD::Pg#COPY-support

--
   Richard Huxton
   Archonet Ltd