Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M48638=pgsql-performance-ar@postgresql.org>)
	id 1TdU0x-0007PH-9X for pgsql-performance@arkaria.postgresql.org;
	Tue, 27 Nov 2012 22:52:27 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M48638=pgsql-performance-ar@postgresql.org>)
	id 1TdU0w-000076-DC for pgsql-performance@arkaria.postgresql.org;
	Tue, 27 Nov 2012 22:52:26 +0000
Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dev@archonet.com>) id 1TdU0v-00006z-KS
	for pgsql-performance@postgresql.org; Tue, 27 Nov 2012 22:52:25 +0000
Received: from archon2012.plus.com ([80.229.41.160] helo=mail.archonet.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dev@archonet.com>) id 1TdU0s-0002Lb-D1
	for pgsql-performance@postgresql.org; Tue, 27 Nov 2012 22:52:25 +0000
Received: from [192.168.1.13] (ariel.office.archonet.com [192.168.1.13])
	by mail.archonet.com (Postfix) with ESMTP id 5D4FE2C673F;
	Tue, 27 Nov 2012 22:52:20 +0000 (GMT)
Message-ID: <50B54424.5010400@archonet.com>
Date: Tue, 27 Nov 2012 22:52:20 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:10.0.10) Gecko/20121027 Icedove/10.0.10
MIME-Version: 1.0
To: Mike Blackwell <mike.blackwell@rrd.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Savepoints in transactions for speed?
References: 
 <CANPAkgs_LvZV-fabTNN-ahiVcwSBAyOnArw1v+QbCePg7on6ZA@mail.gmail.com>
In-Reply-To: 
 <CANPAkgs_LvZV-fabTNN-ahiVcwSBAyOnArw1v+QbCePg7on6ZA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance