| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | jody brownell <jody(dot)brownell(at)q1labs(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Help tuning autovacuum - seeing lots of relationbloat |
| Date: | 2006-06-21 19:38:24 |
| Message-ID: | 20060621193823.GI93655@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jun 21, 2006 at 01:21:05PM -0300, jody brownell wrote:
> Jun 21 13:04:04 vanquish postgres[3311]: [19-1] DEBUG: "target": removed 5645231 row versions in 106508 pages
> Jun 21 13:04:04 vanquish postgres[3311]: [19-2] DETAIL: CPU 3.37s/1.23u sec elapsed 40.63 sec.
> Jun 21 13:04:04 vanquish postgres[3311]: [20-1] DEBUG: "target": found 5645231 removable, 1296817 nonremovable row versions in 114701 pages
> Jun 21 13:04:04 vanquish postgres[3311]: [20-2] DETAIL: 0 dead row versions cannot be removed yet.
So the table contained 5.6M dead rows and 1.3M live rows.
I think you should forget about having autovacuum keep this table
in-check and add manual vacuum commands to your code. Autovac is
intended to deal with 99% of use cases; this is pretty clearly in the 1%
it can't handle.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jody brownell | 2006-06-21 19:40:40 | Re: Help tuning autovacuum - seeing lots of relationbloat |
| Previous Message | Jim C. Nasby | 2006-06-21 19:02:43 | Re: Performance of DOMAINs |