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