| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: automatic REINDEX-ing |
| Date: | 2008-08-12 15:53:58 |
| Message-ID: | 8016.1218556438@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> writes:
> I executed REINDEX by hand and the disk ocupation imediatelly dropped 6
> Giga...!!!
> is there a way to configure postgres to automatically execute the needed
> REINDEXING (on indexes and tables) for a given database....
Generally speaking, there shouldn't be a need for "automatic
reindexing". What the above suggests is that you need more aggressive
routine vacuuming, so that you don't get into this situation in the
first place.
BTW, "more aggressive routine vacuuming" does NOT mean "use vacuum full".
Vacuum full tends to make index bloat worse, not better.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2008-08-12 15:57:11 | Re: Need help returning record set from a dynamic sql query |
| Previous Message | Lennin Caro | 2008-08-12 15:38:09 | Re: automatic REINDEX-ing |