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.rousseau@nnx.com>
To: <pgsql-general@postgresql.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.rousseau@nnx.com>
> Neuronnexion - http://www.neuronnexion.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>