From: Fabricio <fabrixio1@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Recommend dba maintenance tasks on a regular bases
Date: Fri, 12 Sep 2008 11:51:38 -0700
Message-ID: <BLU103-W48E4A0BE4644FCF0BDCAA3FE510@phx.gbl> (raw)
In-Reply-To: <20080912164019.GD2171@commandprompt.com>
References: <200809121149.46137.barbara@turbocorp.com>
<20080912164019.GD2171@commandprompt.com>
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.xLas 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_________________________________________________________________
Live Search premia tus búsquedas, llévate hasta ¡Un Auto!
http://www.ganabuscando.com/Default.aspx=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: fabrixio1@hotmail.com
Subject: Re: Recommend dba maintenance tasks on a regular bases
In-Reply-To: <BLU103-W48E4A0BE4644FCF0BDCAA3FE510@phx.gbl>
References: <200809121149.46137.barbara@turbocorp.com> <20080912164019.GD2171@commandprompt.com> <BLU103-W48E4A0BE4644FCF0BDCAA3FE510@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox