| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Chris <lists(at)deksai(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: stats collector suddenly causing lots of IO |
| Date: | 2010-04-16 18:53:10 |
| Message-ID: | 4BC8B216.8030201@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Josh Kupershmidt wrote:
> And it seems the only way
> to compact the pg_catalog tables is VACUUM FULL + REINDEX on 8.3 -- I
> had tried the CLUSTER on my 9.0 machine and wrongly assumed it would
> work on 8.3, too.
>
Right; that just got implemented a couple of months ago. See the news
from http://www.postgresql.org/community/weeklynews/pwn20100214 for a
summary of how the code was gyrated around to support that. This is a
tough situation to get out of in <9.0 because VACUUM FULL is slow and
takes an exclusive lock on the table. That tends to lead toward an
unpredictable window for required downtime, which is never good.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-04-16 19:22:42 | Re: stats collector suddenly causing lots of IO |
| Previous Message | Josh Kupershmidt | 2010-04-16 18:35:56 | Re: stats collector suddenly causing lots of IO |