Re: INSERTs slow

1) Do you have constraints on the index ie Unique or Primary Key?

2) Do you have any triggers or rules on the table.

3) How often do you do a VACUUM ANALYZE

All these will influence the speed

http://www.pgexplorer.com

GUI Frontend for PostgreSQL

----- Original Message -----

From: "Dominique ROUSSEAU" <d(dot)rousseau(at)nnx(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 26, 2002 11:07 AM
Subject: [GENERAL] INSERTs slow

> Hi,
>
>
> I have a table with around 1.5 millions entries, and INSERTs are very
> slowwwww.
> This table has 3 indices on "char(32)" fields.
>
> Without indices, the INSERTs are fluent, with indices, it crawls :/
>
> Any idea ?
>
> As a sidenote, it was going rather well when the table contained only 1
> million entries.
>
> Dom
>
> --
> Dominique Rousseau <d(dot)rousseau(at)nnx(dot)com>
> Neuronnexion - http://www.neuronnexion.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>