On Fri, 2004-08-13 at 08:10, Ulrich Wisser wrote:
> Hi,
> my inserts are done in one transaction, but due to some foreign key 
> constraints and five indexes sometimes the 100 inserts will take more 
> than 5 minutes.

It is likely that you are missing an index on one of those foreign key'd

Do an EXPLAIN ANALYZE SELECT * FROM foreign_table WHERE foreign_col =
'<insert value>';

Fix them until they're quick.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to