Postgres Pro
Downloads
Home   >   mailing lists

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

From Steve Crawford
Subject Re: UPDATES hang every 5 minutes
Date
Msg-id 46BB9B08.4090606@pinpointresearch.com
Whole thread Raw
In response to UPDATES hang every 5 minutes  (mr19 <marc_rossi@yahoo.com>)
List pgsql-general
Tree view 
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)....

autovacuum_naptime perhaps?

Cheers,
Steve

pgsql-general by date:

Previous
From: Cantor
Date:
Subject: Re: Internal Postgre SQL documentation
Next
From: Tom Lane
Date:
Subject: Re: UPDATES hang every 5 minutes