| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: INSERT extremely slow with large data sets |
| Date: | 2003-11-14 18:19:46 |
| Message-ID: | 20031114181946.GA24964@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kurt Roeckx | 2003-11-14 18:25:36 | Re: 7.4RC2 regression failur and not running stats collector process |
| Previous Message | Dann Corbit | 2003-11-14 18:18:19 | Re: INSERT extremely slow with large data sets |