Re: Massive Inserts Strategies - Mailing list pgsql-performance

From PFC
Subject Re: Massive Inserts Strategies
Date
Msg-id op.s6tofevzcigqcu@apollo13
Whole thread Raw
In response to Massive Inserts Strategies  (ashah <ashah@opuspro.com>)
List pgsql-performance
    For both cases, you could COPY your file into a temporary table and do a
big JOIN with your existing table, one for inserting new rows, and one for
updating existing rows.
    Doing a large bulk query is a lot more efficient than doing a lot of
selects. Vacuum afterwards, and you'll be fine.

pgsql-performance by date:

Previous
From: ashah
Date:
Subject: Massive Inserts Strategies
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Massive Inserts Strategies