From: "G u i d o B a r o s i o" <[EMAIL PROTECTED]>:
> As I see it's 100 inserts every 5 minutes, not only 100 inserts. > > Sure it's extreme for only 100 inserts. I am sorry, I do not quite grasp what you are saying. my understanding was that there are constantly new inserts, coming in bursts of 100 , every 5 minutes. I imagined that the indexes were needed in between. if this is the case, the bunches of 100 inserts should be done inside a transaction (or by 1 COPY statement) if, on the other hand, the inserts happen independently, at a rate of 100 inserts / 5 minutes, then this will not help gnari > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster