Re: INSERT extremely slow with large data sets - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: INSERT extremely slow with large data sets
Date
Msg-id 20031114181946.GA24964@dcc.uchile.cl
Whole thread Raw
In response to INSERT extremely slow with large data sets  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
Responses Re: INSERT extremely slow with large data sets  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
List pgsql-hackers
On Fri, Nov 14, 2003 at 06:36:41PM +1100, Slavisa Garic wrote:

> Rows Present        Start Time        Finish Time
> ------------------------------------------------------------
> 100            1068790804.12           1068790804.12
> 1000            1068790807.87          1068790807.87
> 5000            1068790839.26        1068790839.27
> 10000            1068790909.24          1068790909.26
> 20000            1068791172.82        1068791172.85
> 30000            1068791664.06        1068791664.09 
> 40000            1068792369.94        1068792370.0
> 50000            1068793317.53        1068793317.6
> 60000            1068794369.38        1068794369.47

> [too slow]

Ok, so inserting 60000 rows seems to take 0.09 seconds, and inserting
5000 takes only 0.01.  And your problem is exactly what?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Need help.
Next
From: "Dann Corbit"
Date:
Subject: Re: INSERT extremely slow with large data sets