Re: bulk insert performance problem - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: bulk insert performance problem
Date
Msg-id 20080408084139.GA22986@depesz.com
Whole thread Raw
In response to bulk insert performance problem  ("Christian Bourque" <christian.bourque@gmail.com>)
List pgsql-performance
On Mon, Apr 07, 2008 at 11:01:18PM -0400, Christian Bourque wrote:
> I have a performance problem with a script that does massive bulk
> insert in 6 tables. When the script starts the performance is really
> good but will degrade minute after minute and take almost a day to
> finish!

how do you do this bulk insert?

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-performance by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: bulk data loading
Next
From: Ivan Voras
Date:
Subject: Re: Looking for bottleneck during load test