Re: Efficient Way to Merge Two Large Tables

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Joshua Rubin" <jrubin(at)esoft(dot)com>
Cc: "Julian Mehnle" <julian(at)mehnle(dot)net>,pgsql-general(at)postgresql(dot)org
Subject: Re: Efficient Way to Merge Two Large Tables
Date: 2010-07-17 07:18:28
Message-ID: 8084cdb2-6e87-408c-b48e-3ffb0ca82022@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joshua Rubin wrote:

> I need to figure out why this is slow, and if there is any faster way.

Have you considered INSERTing into a third table that would replace both
source tables when it's over? The target table would initially have no index.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-07-17 07:55:12 Re: pg_dump and --inserts / --column-inserts
Previous Message Craig Ringer 2010-07-17 01:13:14 Re: pg_dump and --inserts / --column-inserts