| From: | Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr> |
|---|---|
| To: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Time to insert |
| Date: | 2001-05-03 10:50:03 |
| Message-ID: | 3AF137DB.7CB77570@amwdb.u-strasbg.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
It is a little difficult to perform VACUUM analyse because I'm writing an
application in C++ using libpq++.
I Use version 7.0.3
I try COPY too but result was about the same.
Renaud.
Einar Karttunen wrote:
> On Thu, 3 May 2001, Renaud Thonnart wrote:
>
> > Hi everyone
> > Could someone explain me why time of insertion become that long when
> > table increase ?
> > For the same kind of insertion:
> > When table is empty : 0.03s/row
> > Table has 3663 rows : 2.07s/row
> > Is that normal ?
> >
> > Sincerely, Renaud THONNART
> >
> Have you performed a VACUUM [ANALYZE]? If you are inserting data in larger
> patches consider using copy or dropping indexes. What version of pgsql are
> you using? There used to be (if I remember correctly) a bug in 7.1 betas
> that made the inserts slow down.
>
> - Einar Karttunen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Einar Karttunen | 2001-05-03 11:16:20 | Re: Time to insert |
| Previous Message | Einar Karttunen | 2001-05-03 10:36:51 | Re: Time to insert |