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