Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX by table or by index? - Mailing list pgsql-admin

From Tom Lane
Subject Re: REINDEX by table or by index?
Date
Msg-id 18182.1055437283@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX by table or by index?  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-admin
Tree view 
Jeff Boes <jboes@nexcerpt.com> writes:
> Given a fairly large (7 MRows or so) table with more than one index
> (say, two): would it be theoretically faster to do
>   REINDEX TABLE "foo";
> or
>   REINDEX INDEX "ix_foo_one";
>   REINDEX INDEX "ix_foo_two";

I doubt you could possibly detect any difference.  The indexes are
rebuilt one at a time in any case, and the statement-level overhead
is insignificant.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backends "idle in transaction"
Next
From: Tom Lane
Date:
Subject: Re: Still confused about VACUUM vs. VACUUM FULL