Skip site navigation (1) Skip section navigation (2)

Re: Postgres 8.0/Windows 2000 Load testing

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bellan Saravanan <sarbx(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres 8.0/Windows 2000 Load testing
Date: 2004-08-26 01:47:21
Message-ID: 200408260147.i7Q1lLG20965@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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 
> http://ltp.sourceforge.net/dotshowto.php#SEC26,
> 
> "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 MomjianDate: 2004-08-26 01:49:20
Subject: Re: Inconsistent pg_ctl behaviour: start vs. runservice
Previous:From: Gaetano MendolaDate: 2004-08-26 01:44:11
Subject: Re: BUG #1231: Probelm with transactions in stored code.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group