| From: | mr19 <marc_rossi(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | UPDATES hang every 5 minutes |
| Date: | 2007-08-07 16:23:23 |
| Message-ID: | 12037580.post@talk.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
--
View this message in context: http://www.nabble.com/UPDATES-hang-every-5-minutes-tf4231199.html#a12037580
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Staubo | 2007-08-07 16:37:11 | Re: clustering failover... ala Oracle Parallel server |
| Previous Message | Mason Hale | 2007-08-07 16:18:09 | Re: pg_dump of only the structure from a client such as ruby |