*Delete indexes and recreate them after the insert.
*Disable auto-commit
*Perform a copy will be faster, sure.

Best wishes,

> Hi,
> is there anything I can doo to speed up inserts? One of my tables gets 
> about 100 new rows every five minutes. And somehow the inserts tend to 
> take more and more time.
> Any suggestions welcome.
> Ulrich
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to