Re: [PERFORM] raise or lower transaction timeout?

[Matthew Hixson]

On Wednesday, July 2, 2003, at 07:04 PM, Ang Chin Han wrote:

Matthew Hixson wrote:

I don't know what that is.  I don't have an iostat utility on the 
machine.  This is a Debian Linux machine.  Is there a package with 
that utility in it?
apt-get install sysstat

apt-cache search iostat can be used to search for it, or use 
http://www.debian.org/distrib/packages
Thank you.  iostat shows:

Linux 2.4.20 (datweb10)         07/02/03

avg-cpu:  %user   %nice    %sys   %idle
          10.60    0.00    2.70   86.71
Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
dev8-0            7.01        32.59       230.79   33242314  235421336
Guess I need to read up on what that's telling me.
  Thanks again,
    -M@
---------------------------(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