| From: | "Mario Alberto Soto Cordones" <mario_soto(at)venezolanadeavaluos(dot)com> |
|---|---|
| To: | <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | <mario_soto(at)venezolanadeavaluos(dot)com>, <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Consulta de indices |
| Date: | 2004-05-23 21:31:09 |
| Message-ID: | 43797.200.35.66.77.1085347869.squirrel@mail.venezolanadeavaluos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Los que estan con valor 0, nunca se han usado ????
> On Sun, May 23, 2004 at 03:53:45PM -0400, Mario Alberto Soto Cordones
> wrote:
>> Hola lista, existe alguna forma de saber cual indice o cueles indices
>> nunca se han ocupado, para poder asi eliminarlos.
>
> Mira la vista pg_stat_user_indexes.
>
> Ojo con los indices unicos (UNIQUE), esos no puedes eliminarlos aunque
> no se usen nunca.
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> "The only difference is that Saddam would kill you on private, where the
> Americans will kill you in public" (Mohammad Saleh, 39, a building
> contractor)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: no olvides aumentar la configuración del "free space map"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-05-23 21:39:53 | Re: Consulta de indices |
| Previous Message | Alvaro Herrera | 2004-05-23 21:08:53 | Re: Consulta de indices |