insertion becoming slow

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: insertion becoming slow
Date: 2005-09-27 08:34:59
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118EC74@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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).


Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2005-09-27 09:18:00 Re: Can't change language through LC_MESSAGES
Previous Message Csaba Nagy 2005-09-27 08:24:02 Re: insertion becoming slow