Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Massive Inserts Strategies
- From: PFC <lists(at)peufeu(dot)com>
- To: ashah <ashah(at)opuspro(dot)com>, pgsql <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Massive Inserts Strategies
- Date: Wed, 22 Mar 2006 17:07:52 +0100
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.
- References:
- Massive Inserts Strategies
- From: ashah
- Massive Inserts Strategies
- Prev by Date: Massive Inserts Strategies
- Next by Date: Re: Massive Inserts Strategies
- Previous by thread: Massive Inserts Strategies
- Next by thread: Re: Massive Inserts Strategies
- Indexes: