| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Marc Cousin" <mcousin(at)sigma(dot)fr> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: insert performance for win32 |
| Date: | 2005-09-07 12:04:15 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD28C@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> > One thing I did notice that in a 250k insert transaction the insert
time
> > grows with #recs inserted. Time to insert first 50k recs is about
27
> > sec and last 50 k recs is 77 sec. I also confimed that size of
table is
> > not playing a role here.
> >
> > Marc, can you do select timeofday() every 50k recs from linux? Also
a
> > gprof trace from linux would be helpful.
> >
>
> Here's the timeofday ... i'll do the gprof as soon as I can.
> Every 50000 rows...
>
Were those all in a single transaction?
Merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2005-09-07 13:08:18 | Re: [PERFORM] insert performance for win32 |
| Previous Message | Marc Cousin | 2005-09-07 12:02:02 | Re: insert performance for win32 |