PostgreSQL Discussion - insertion becoming slow

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

insertion becoming slow

surabhi.ahuja

2005-09-27, 7:23 am

it is the commit call to postgres that suddently takes more time than normal(as observed for other inserts)
it seems as if postgres does some activity (on its own) after some installs.

thats why i have observed this pattern ....i.e. commit taking less time for some installs (eg 1000) ..then suddently becoming high an dthen dropping back ....
then again takes normal time for another 1000 ...and again becomes high (for 6 - 7 intstalls).

Sponsored Links