Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Migration study, step 1: bulk write performance optimization

  • From: "Craig A. James" <cjames(at)modgraph-usa(dot)com>
  • To: Mikael Carneholm <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
  • Cc: pgsql-performance(at)postgresql(dot)org
  • Subject: Re: Migration study, step 1: bulk write performance optimization
  • Date: Mon, 20 Mar 2006 07:12:18 -0800
  • Message-id: <441EC652(dot)1010807(at)modgraph-usa(dot)com>
Mikael Carneholm wrote:


I am responisble for an exciting project of evaluating migration of a
medium/large application for a well-known swedish car&truck manufacturer
... The goal right now is to find the set of parameters that gives as
short bulk insert time as possible, minimizing downtime while the data
itself is migrated.


If you haven't explored the COPY command yet, check it out.  It is stunningly fast compared to normal INSERT commands.

  http://www.postgresql.org/docs/8.1/static/sql-copy.html

pg_dump and pg_restore make use of the COPY command.  Since you're coming from a different vendor, you'd have to dump the data into a COPY-compatible set of files yourself.  But it will be worth the effort.

Craig
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group