Re: Time to insert

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