As I see it's 100 inserts every 5 minutes, not only 100 inserts. Sure it's extreme for only 100 inserts.
Cheers, Guido > "G u i d o B a r o s i o" <[EMAIL PROTECTED]> wrote: > > [speeding up 100 inserts every 5 minutes] > > > Tips! > > *Delete indexes and recreate them after the insert. > > sounds a bit extreme, for only 100 inserts > > gnari > > > > > > ---------------------------(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 7: don't forget to increase your free space map settings
