Re: INSERTs slow - Mailing list pgsql-general

From PGMailList
Subject Re: INSERTs slow
Date
Msg-id 001801c1d4ca$771cc120$05faa8c0@edios
Whole thread Raw
In response to INSERTs slow  (Dominique ROUSSEAU <d.rousseau@nnx.com>)
Responses Re: INSERTs slow
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Arsalan Zaidi"
Date:
Subject: Speed diff cause by multi-byte support
Next
From: Dominique ROUSSEAU
Date:
Subject: Re: INSERTs slow