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