Re: bulk insert performance problem

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Christian Bourque <christian(dot)bourque(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: bulk insert performance problem
Date: 2008-04-08 08:41:39
Message-ID: 20080408084139.GA22986@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2008-04-08 09:01:59 Re: Looking for bottleneck during load test
Previous Message Magnus Hagander 2008-04-08 07:40:17 Re: bulk data loading