INSERTs slow - Mailing list pgsql-general

From Dominique ROUSSEAU
Subject INSERTs slow
Date
Msg-id 20020326100730.Q2466@neuronnexion.fr
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Arrays Design Question
Next
From: Ferruccio Zamuner
Date:
Subject: Data integrity and sanity check