Re: bulk loading table via join of 2 large staging tables

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: bulk loading table via join of 2 large staging tables
Date: 2014-01-03 16:31:11
Message-ID: 87mwjdf2nk.fsf@kolob.subpolar.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 31 Dec 2013 02:23:30 +0000,
Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> wrote:

> This should help... In each temporary table convert the time parts to
> a timestamp, then create an index on each of these, then join on the
> timestamp.

[...]

Thank you, these were very useful suggestions, and lead to a very
efficient table loading.

Cheers,

--
Seb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2014-01-03 19:20:28 Suddenly all tables were gone
Previous Message Andrew Sullivan 2014-01-03 15:43:22 Re: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?