Re: How to optimize insert statements ? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to optimize insert statements ?
Date
Msg-id 9177.1185287609@sss.pgh.pa.us
Whole thread Raw
In response to How to optimize insert statements ?  ("Christian Leclerc" <cleclerc@ilog.fr>)
Responses Re: How to optimize insert statements ?  ("Christian Leclerc" <cleclerc@ilog.fr>)
List pgsql-novice
"Christian Leclerc" <cleclerc@ilog.fr> writes:
> I'm encountering a performance issue with insert statements.

It looks to me like your trigger is the entire cause of the slowness.
I think you would be well advised to get rid of it and use a serial
column (ie a sequence object) instead of a handmade, poorly performing
substitute for sequences.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Christian Leclerc"
Date:
Subject: How to optimize insert statements ?
Next
From: "Claude Chaloux"
Date:
Subject: DEFERABLE vs. NOT DEFERABLE constraints