Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1F22F64FCD2 for ; Fri, 12 Sep 2008 15:51:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99392-08 for ; Fri, 12 Sep 2008 15:51:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from blu0-omc1-s8.blu0.hotmail.com (blu0-omc1-s8.blu0.hotmail.com [65.55.116.19]) by postgresql.org (Postfix) with ESMTP id 1307664FCCC for ; Fri, 12 Sep 2008 15:51:40 -0300 (ADT) Received: from BLU103-W48 ([65.55.116.7]) by blu0-omc1-s8.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 12 Sep 2008 11:51:39 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_caf13bd4-aa27-4bd0-a8d1-23e56d93ddec_" X-Originating-IP: [201.144.221.242] From: Fabricio To: Subject: Re: Recommend dba maintenance tasks on a regular bases Date: Fri, 12 Sep 2008 11:51:38 -0700 Importance: Normal In-Reply-To: <20080912164019.GD2171@commandprompt.com> References: <200809121149.46137.barbara@turbocorp.com> <20080912164019.GD2171@commandprompt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 12 Sep 2008 18:51:39.0190 (UTC) FILETIME=[96DF2D60:01C91508] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.118 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RCVD_IN_SORBS_WEB=1.117 X-Spam-Level: * X-Archive-Number: 200809/121 X-Sequence-Number: 30214 --_caf13bd4-aa27-4bd0-a8d1-23e56d93ddec_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 The help of reindex say: =20 Also=2C for B-tree indexes a freshly-constructed index is somewhat faster t= o access than one that has been updated many times=2C because logically adj= acent pages are usually also physically adjacent in a newly built index. (T= his consideration does not currently apply to non-B-tree indexes.) It might= be worthwhile to reindex periodically just to improve access speed.=20 I have a reindex of my databases periodically =20 Sorry for the English translation of google I have PostgreSQL 8.1.x The dat= abases that we have has many updates and were being slow=2C revising found = that some index were bigger than it should be=2C did not agree to the size = of the table. I made a reindex of the table and consultation is his much f= aster and the index remained very small. We therefore began a scheduled tas= k that reidex my batadase periodically. =20 Mensaje original: Tengo postgresql 8.1.xLas bases de datos que nosotros tenemos tienen muchas= actualizaciones y se estaban poniendo lentas=2C revisando encontre que uno= s indices estaban mas grandes de lo que deberian de estar=2Cno estaba de ac= uerdo al tama=F1o de la tabla. Aplique un reindex a la tabla y la consulta= se hiso mucho mas rapida y el indice quedo muy peque=F1o.Por lo tanto puse= una tarea programada que me reidex mis bases de datos periodicamente. > Date: Fri=2C 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=2C Sep 12=2C 2008 at 11:49:46AM -0400= =2C Barbara Stephenson wrote:> > I have recommend the below to my group but= not sure if reindexing should be > > involved since autovacuum is on? > > = No=2C there's no reason to reindex regularly if everything is working as> e= xpected. > > > > > How can I be sure auto vacumming is working fine? > > Ch= eck the pg_statitistic_all_tables entries in last_autovacuum and> last_auto= analyze.> > A> > > -- > Andrew Sullivan> ajs@commandprompt.com> +1 503 667 = 4564 x104> http://www.commandprompt.com/> > -- > Sent via pgsql-admin maili= ng list (pgsql-admin@postgresql.org)> To make changes to your subscription:= > http://www.postgresql.org/mailpref/pgsql-admin _________________________________________________________________ Live Search premia tus b=FAsquedas=2C ll=E9vate hasta =A1Un Auto! http://www.ganabuscando.com/Default.aspx= --_caf13bd4-aa27-4bd0-a8d1-23e56d93ddec_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable  =3B
The help of reindex say:
 =3B
Also=2C for B-tree indexes a freshly-constructed index is somewhat faster t= o access than one that has been updated many times=2C because logically adj= acent pages are usually also physically adjacent in a newly built index. (T= his 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 =3B

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=2C revising found that some index were bigger than it = should be=2C did not agree to the size of the table. =3BI made a reinde= x of  =3Bthe table and consultation is his much faster and the index re= mained very small.
We therefore began a scheduled task that =3B rei= dex my batadase periodically.
 =3B

Mensaje original:
Tengo postgresql 8.1.x
Las bases de datos que nosotros tenemos tienen mu= chas actualizaciones y se estaban poniendo lentas=2C revisando encontre que= unos indices estaban mas grandes de lo que deberian de estar=2Cno estaba d= e acuerdo al tama=F1o de la tabla. =3BAplique un reindex a  =3Bla t= abla y la consulta se hiso mucho mas rapida y el indice quedo muy peque=F1o= .
Por lo tanto puse una tarea programada que me reidex mis bases de dato= s periodicamente.



>=3B Date: Fri=2C 12 Sep 2008 12:40:19 -0400
>=3B From: ajs@commandp= rompt.com
>=3B To: pgsql-admin@postgresql.org
>=3B Subject: Re: [= ADMIN] Recommend dba maintenance tasks on a regular bases
>=3B
>= =3B On Fri=2C Sep 12=2C 2008 at 11:49:46AM -0400=2C Barbara Stephenson wrot= e:
>=3B >=3B I have recommend the below to my group but not sure if = reindexing should be
>=3B >=3B involved since autovacuum is on? >=3B
>=3B No=2C there's no reason to reindex regularly if everythi= ng is working as
>=3B expected.
>=3B
>=3B >=3B
>= =3B >=3B How can I be sure auto vacumming is working fine?
>=3B >=3B Check the pg_statitistic_all_tables entries in last_autovacuum and<= BR>>=3B last_autoanalyze.
>=3B
>=3B A
>=3B
>=3B >=3B --
>=3B Andrew Sullivan
>=3B ajs@commandprompt.com
&g= t=3B +1 503 667 4564 x104
>=3B http://www.commandprompt.com/
>=3B=
>=3B --
>=3B Sent via pgsql-admin mailing list (pgsql-admin@po= stgresql.org)
>=3B To make changes to your subscription:
>=3B htt= p://www.postgresql.org/mailpref/pgsql-admin



Conoce el pe= rfil completo de todos tus amigos de Windows Live Messenger justo aqu=ED: <= a href=3D'http://home.services.spaces.live.com/' target=3D'_new'>Windows Li= ve Spaces = --_caf13bd4-aa27-4bd0-a8d1-23e56d93ddec_--