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