Re: UPDATES hang every 5 minutes - Mailing list pgsql-general

From Tom Lane
Subject Re: UPDATES hang every 5 minutes
Date
Msg-id 3942.1186702641@sss.pgh.pa.us
Whole thread Raw
In response to UPDATES hang every 5 minutes  (mr19 <marc_rossi@yahoo.com>)
List pgsql-general
mr19 <marc_rossi@yahoo.com> writes:
> 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).

Checkpoints?

> I have run htop/top on the machine during this time period and do not see
> anything unusual.

Try watching "vmstat 1" --- your machine is probably I/O bound not
CPU bound.

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: UPDATES hang every 5 minutes
Next
From: Joseph S
Date:
Subject: Re: UPDATES hang every 5 minutes