Re: RES: [SQL] Lock Problem

2006-08-25 Thread Andrew Sullivan
On Thu, Aug 24, 2006 at 06:12:32PM -0300, André José Guergolet wrote: > > My system, checks if my script is running in each machine at this > table, this table has 360 rows and has 50-100 updates per minute in > columns STATE and STATEDATE. How often are you vacuuming it? Long-running UPDATEs wi

Re: RES: [SQL] Lock Problem

2006-08-24 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > On Thu, 2006-08-24 at 16:12, André José Guergolet wrote: >> My system, checks if my script is running in each machine at this table, >> this table has 360 rows and has 50-100 updates per minute in columns STATE >> and STATEDATE. > Are you vacuuming t

Re: RES: [SQL] Lock Problem

2006-08-24 Thread Scott Marlowe
On Thu, 2006-08-24 at 16:12, André José Guergolet wrote: > Sorry, I have a table with 360 rows, in this table I control the state of > machines on network: > > > IpState StateDate > 172.20.0.39 Running 2006-08-23 00:00:00 > 172.20.0.59 Running 20

RES: [SQL] Lock Problem

2006-08-24 Thread André José Guergolet
Sorry, I have a table with 360 rows, in this table I control the state of machines on network: Ip State StateDate 172.20.0.39 Running 2006-08-23 00:00:00 172.20.0.59 Running 2006-08-23 00:00:00 172.20.0.72 Running 2006-08-23 00:0