Re: Savepoints in transactions for speed?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Savepoints in transactions for speed?
Date: 2012-11-27 22:52:20
Message-ID: 50B54424.5010400@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2012-11-27 23:17:55 Re: How to keep queries low latency as concurrency increases
Previous Message Mike Blackwell 2012-11-27 22:04:42 Savepoints in transactions for speed?