| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Joao Ferreira gmail" <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: automatic REINDEX-ing |
| Date: | 2008-08-12 16:09:31 |
| Message-ID: | dcc563d10808120909g35e4adc1oc260cfe6d621e5ed@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Aug 12, 2008 at 10:04 AM, Joao Ferreira gmail
<joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> wrote:
>
> On Tue, 2008-08-12 at 11:53 -0400, Tom Lane wrote:
>> TW, "more aggressive routine vacuuming" does NOT mean "use vacuum
>> full".
>> Vacuum full tends to make index bloat worse, not better.
>>
>> regards, tom lane
>>
> Ok. so what does it mean ?
>
>
>
> I'm a bit lost here. I'm currently executing VACUUM FULL _and_ REINDEX
> (tbls & idxs) every week.
>
> Should I keep the REINDEX and drop VACUUM FULL ?
>
> How do I iterate to a better approach ?
It's better to run REGULAR vacuums more often than to vacuum full OR
reindex OR both.
If your machine doesn't have the I/O bandwidth to withstand being
vacuumed during the day then you either have to have a fairly large
free space map and vacuum off hours or buy a machine with more I/O
bandwidth.
With the sleep settings in vacuum and autovacuum you can usually get
away with autovacuum running during the day.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | William Garrison | 2008-08-12 16:09:50 | Re: automatic REINDEX-ing |
| Previous Message | Tom Lane | 2008-08-12 16:09:07 | Re: ftell error during pg_dump |