Re: INSERTs slow

Have you tried dropping and recreating the index.

or

REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]

Maybe that index of yours is not so kosher

http://www.pgexplorer.com

----- Original Message -----
From: "Dominique ROUSSEAU" <d(dot)rousseau(at)nnx(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, March 26, 2002 3:40 PM
Subject: Re: [GENERAL] INSERTs slow

> Le Tue, Mar 26, 2002 at 03:30:58PM +0200, PGMailList
[pgmail(at)pgexplorer(dot)com] a écrit:
> > 1) Do you have constraints on the index ie Unique or Primary Key?
>
> they are just :
> CREATE INDEX idx1 ON table(field1);
>
> > 2) Do you have any triggers or rules on the table.
> >
> > 3) How often do you do a VACUUM ANALYZE
>
> that's what I started doing, but doesn't change much :/
> once a day
> (there are thousands of INSERTs each day)
>
> Dom
>
> > ----- 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
> > >
> > > 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
> > >
>
> --
> Dominique Rousseau <d(dot)rousseau(at)nnx(dot)com>
> Neuronnexion - http://www.neuronnexion.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>