The help of reindex say:
Also, for B-tree indexes a freshly-constructed index is somewhat faster to access than one that has been updated many times, because logically adjacent pages are usually also physically adjacent in a newly built index. (This consideration does not currently apply to non-B-tree indexes.) It might be worthwhile to reindex periodically just to improve access speed.
I have a reindex of my databases periodically
Sorry for the English translation of google
I have PostgreSQL 8.1.x
The databases that we have has many updates and were being slow, revising found that some index were bigger than it should be, did not agree to the size of the table. I made a reindex of the table and consultation is his much faster and the index remained very small.
We therefore began a scheduled task that reidex my batadase periodically.
Mensaje original:
Tengo postgresql 8.1.x
Las bases de datos que nosotros tenemos tienen muchas actualizaciones y se estaban poniendo lentas, revisando encontre que unos indices estaban mas grandes de lo que deberian de estar,no estaba de acuerdo al tamaño de la tabla. Aplique un reindex a la tabla y la consulta se hiso mucho mas rapida y el indice quedo muy pequeño.
Por lo tanto puse una tarea programada que me reidex mis bases de datos periodicamente.
> Date: Fri, 12 Sep 2008 12:40:19 -0400
> From: ajs@commandprompt.com
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Recommend dba maintenance tasks on a regular bases
>
> On Fri, Sep 12, 2008 at 11:49:46AM -0400, Barbara Stephenson wrote:
> > I have recommend the below to my group but not sure if reindexing should be
> > involved since autovacuum is on?
>
> No, there's no reason to reindex regularly if everything is working as
> expected.
>
> >
> > How can I be sure auto vacumming is working fine?
>
> Check the pg_statitistic_all_tables entries in last_autovacuum and
> last_autoanalyze.
>
> A
>
>
> --
> Andrew Sullivan
> ajs@commandprompt.com
> +1 503 667 4564 x104
> http://www.commandprompt.com/
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Conoce el perfil completo de todos tus amigos de Windows Live Messenger justo aquí:
Windows Live Spaces