Bellan Saravanan wrote:
> While performing Load testing using DOTS
> http://ltp.sourceforge.net/dotshowto.php ,
> during the tests, an update to a specific table starts hanging.
> The test name is called BTCJ2
> "This test case mainly uses SQL commands to execute database operations such
> as insert, update, select and delete. This test case uses tables BASIC1,
> BASIC2, BASIC3. For details about the tables, refer to Appendix A."
> Postgres itself was running fine and accepting new connections and able to
> perform queries on the same table. Only the UPDATE was hanging.
> There was no interesting messages in the log file. I was running with debug
> level 2. I can see the last line which prints the UPDATE statement. Using
> debug level 3 the file grows very large and it very slow.
> Let me know if you want anymore information.
Any chance of testing this on Unix? It might be some way our MVCC is
interacting with the test and not a Win32-specific issue.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2004-08-26 01:49:20|
|Subject: Re: Inconsistent pg_ctl behaviour: start vs. runservice|
|Previous:||From: Gaetano Mendola||Date: 2004-08-26 01:44:11|
|Subject: Re: BUG #1231: Probelm with transactions in stored code.|