Postgres Pro
Downloads
Home   >   mailing lists

Re: bulk loading table via join of 2 large staging tables - Mailing list pgsql-general

From David Johnston
Subject Re: bulk loading table via join of 2 large staging tables
Date
Msg-id 1388455480960-5784870.post@n5.nabble.com
Whole thread Raw
In response to bulk loading table via join of 2 large staging tables  (Seb <spluque@gmail.com>)
List pgsql-general
Tree view 
Quick thoughts:

On both tables:

Convert your date-time varchar fields into a single epoch/integer field.
Create an index of that epoch/integer field.

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/bulk-loading-table-via-join-of-2-large-staging-tables-tp5784869p5784870.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Seb
Date:
Subject: bulk loading table via join of 2 large staging tables
Next
From: Andrew Sullivan
Date:
Subject: Re: bulk loading table via join of 2 large staging tables