Re: 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