Re: UPDATES hang every 5 minutes

Keep an eye on  pg_stat_activity and pg_locks to see if any lock
contention is going on.

mr19 wrote:
> I have a process that updates ~ 1500 rows in a table once a second.  Every 5
> minutes (almost exactly) the update takes ~ 15 seconds (normally < 1).  I
> have run htop/top on the machine during this time period and do not see
> anything unusual.  I am running postgres 8.1.8 on a FC6 box.
>
> Any type of internal accounting/logging set to 5 minute intervals by default
> within postgres?  Right now I am looking at pg_stats activity to see if
> there is anything there but so far have had no luck.
>
> TIA
> Marc