| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Jens Wilke <jens(at)wilke(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_reorg |
| Date: | 2011-04-18 22:32:01 |
| Message-ID: | 7D517F9B-20AF-4977-8CA1-B5849F182B7B@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Apr 19, 2011, at 3:40 AM, Jens Wilke wrote:
> yes, we used it to reduce massive bloat after a database split and
> were very satisfied.
> IIRC "vacuum full" mode rewrites the indexes as well.
Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table.
> There's a proposal about an alternative to pg_reorg on depesz' Blog:
> http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
For huge bloats, mentioned Method is slower.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-04-18 23:44:08 | Re: Help - corruption issue? |
| Previous Message | Jens Wilke | 2011-04-18 22:10:14 | Re: pg_reorg |