Scott Marlowe <smarlowe@g2switchworks.com> 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
updatesper 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