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 the database often enough? Is this table suffering
> from bloat?
That's my bet. With numbers like those, that table has to get vacuumed
every few minutes to keep performance from going into the tank.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
