Postgres Pro
Downloads
Home   >   mailing lists

Re: Massive Inserts Strategies - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Massive Inserts Strategies
Date
Msg-id 442961E4.3010001@logix-tt.com
Whole thread Raw
In response to Re: Massive Inserts Strategies  (ashah <ashah@opuspro.com>)
List pgsql-performance
Tree view 
Hi, ashah,

ashah wrote:
> I tried this solution, but ran into following problem.
>
> The temp_table has columns (col1, col2, col3).
>
> The original_table has columns (col0, col1, col2, col3)

> Now the extra col0 on the original_table is the unique generated ID by
> the database.

INSERT INTO original_table (col1, col2, col3) SELECT col1, col2, col3
FROM temp_table WHERE ...

HTH,
Markus




--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: simple join uses indexes, very slow
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: simple join uses indexes, very slow